Qlikview ignore selection in text box (object)

[matthewp]

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

[sunny_talwar]

Try this:

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

[sunny_talwar · Accepted solution]

This?

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

[kuczynska]

Did you try something like:

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

sunindia The original expressions works fine for me; two other expressions are returning errors regarding nested aggregation (I would assume that might be coming from num() function)

matthewp‌ - can you please confirm what was the result of your original expression?