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: 
Not applicable

variables in Set analysis

Hi I am using the below expression and its not working...can anybody tell me what's wrong with that

sum({$<Status_FA={'A'},Month_No={$(var_month)}>}Revenue)-sum({$<Status_FA={'A'},Month_No={$(var_month)}>}Discount)

where var_month is the variable which is assigned the value as field Month_No

Month_No is in date format.

Please help me

11 Replies
anbu1984
Master III
Master III

can you share your app?

Anonymous
Not applicable
Author

Anuj,


can you please tell us how you created/declared  var_month and Month_No


else it will  be all guess work ?



anant