topic set analysis question in QlikView

set analysis question

Thu, 28 Feb 2013 09:44:13 GMT

Hello everybody,

I've a question of set analysis. I have a dynamique tab whith a variable and a date (year/month). For all values i have a pourcentage calcul like this:

sum(comptage)/sum(total <MOIS_DEC,lib_var>comptage)

The probleme is that next that i wan't to have this same expression but for a reference date. So i want in the column 201208 the sum(comptage)/sum(total <MOIS_DEC,lib_var> comptage) for 201208 but also for 201209. So in my tab i want the sum for all the month and next the sum for my reference date.

I've a solution but the sum is affiched uniquely in the column 201209 not in all with the expression sum({$<MOIS_DEC={201209}>}comptage)/(sum(total{$<MOIS_DEC={201209}>comptage}!!

In my attach document you can see my problem i want that IS in 201209 are also in 201208,201207....

Thank you for your help

and have a nice day

Re: set analysis question

Gysbert_Wassenaar — Thu, 28 Feb 2013 09:57:27 GMT

Maybe something like this:

rangesum(after(sum(comptage),0,2))/rangesum(after(sum(total <MOIS_DEC,lib_var>comptage),0,2))

Re: set analysis question

Thu, 28 Feb 2013 10:09:01 GMT

hello Gysbert your expression doesn't work, i've not the expression of 201209 in my column IS.

I just want to have the same expression but the valor for 201209 in all my column so in all MOIS_DEC.