Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,
the correct set analysis syntax is:
sum({<month={'$(=$(maxmonth))'}>}[order total])
best wishes.
Thank you so much.