Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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