topic Re: Needed Set Analysis Help in QlikView

Needed Set Analysis Help

bharatkishore — Mon, 04 Jul 2016 16:14:45 GMT

Hi All,

I have a Brand,Month, Market fields.

And the data looks like

Now i have taken a line chart and i needed expression as 62105/2696085, 439900/2696085.

I have written as =(sum(Target_Impressions)/sum(TOTAL{<Target_Month=,Voice_Brand=>} Target_Impressions))

I am getting correct values when i am selecting month and Brand filters.. But i need to get the values without making any filters.

Kindly help.

Thanks,

Bharat

swuehl — Mon, 04 Jul 2016 16:59:42 GMT

What are the dimensions used in your line chart?

I think you probably just need to use the TOTAL qualifier with a field list and appropriate dimensions.

In a more complex scenario, I think you probably need to use advanced aggregation rather than set analysis.

like using Target_Month and Voice_Brand as dimensions in your line chart and as expression

=Sum(Target_Impressions) / Sum(TOTAL<Target_Month> Target_Impressions)

bharatkishore — Mon, 04 Jul 2016 17:05:30 GMT

Thanks a lot.. Exactly what i needed..