Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
jduenyas
Specialist
Specialist

Another set analysis question

Hi all

This expression works correctly for me:   =sum({1<QUOTA_Month={1}>}  QUOTA_Quota).

But when substituing in the expression

QUOTA_Month={1}

with

QUOTA_Month={$(=num(month(today())))}

=sum({1<QUOTA_Month={$(=num(month(today())))}>}  QUOTA_Quota)

it does not work.

Am I doing something wrong?

QUOTA_Month is numeric

Thanks

2 Replies
Not applicable

=sum({1<QUOTA_Month={'$(=num(month(today())))'}>}  QUOTA_Quota)

jduenyas
Specialist
Specialist
Author

Thanks you Thomas