topic Re: Set Analysis in QlikView

Set Analysis

gayathridevi24 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 10 Sep 2018 12:47:27 GMT

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 — Mon, 10 Sep 2018 13:41:08 GMT

the correct set analysis syntax is:

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

best wishes.

gayathridevi24 — Tue, 11 Sep 2018 05:42:41 GMT

Thank you so much.