Set Analysis

[gayathridevi24]

Hi All,

I am using set analysis for comparing previous and current month total of order.

I have used the variable as maxmonth to found the maximum of month in the script. The expression used as below

sum({<month={'$(maxmonth)'}>}[order total])

Please find the attached qvw file. Can somebody please help me to solve this issue.

Thanks and Regards,

Gayathri devi

[kfoudhaily]

Hello,

here is the syntax for the set analysis with a variable:

sum({<month={'$(=$(maxmonth))'}>}[order total])

please find document in attachement, I have added a variable for previous month.

please note that there is no data for moth 6 in app and that's why it shows 0.

for previous it's ok

regards,

[wade12]

the correct set analysis syntax is:

sum({<month={'$(=$(maxmonth))'}>}[order total])

best wishes.

[gayathridevi24]

Thank you so much.