qlikviewqliksenseset-analysisqlik-expression

Qlikview ignore selection in text box (object)

I have a text box that contains an expression, however i dont want it to be affected by the selections in the list boxes.

=SUM(IF( (date(Monthname(C_DATE),'MMM-YY')) >=(AddMonths(Today(),-12)),1,0))
Solution

  • Using the {1} prefix in the expression will ignore all selections from listboxes (or other).

    =Sum({1} If((Date(Monthname(C_DATE), 'MMM-YY')) >=(AddMonths(Today(),-12)), 1, 0))