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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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