Qlikview ignore selection in text box (object)

575 Views Asked by At

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))
1

There are 1 best solutions below

0
On BEST ANSWER

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))