topic Preserve sum() when selecting a field in QlikView

Preserve sum() when selecting a field

sifatnabil — Fri, 23 Sep 2016 10:43:48 GMT

Hi all,

In my stacked bar chart dimension, I have MonthYear and Client, and in expression, I show % VOLUME per client per month:

sum(VOLUME)/sum(TOTAL <MonthYear> VOLUME)

Now, there are 50+ clients. I want to show just a select few clients of my own choosing. Selecting those clients changes the % values completely. Is there a way to preserve the value of sum(TOTAL <MonthYear> VOLUME) when selecting clients?

Re: Preserve sum() when selecting a field

swuehl — Fri, 23 Sep 2016 10:49:12 GMT

sum({<ClientField= >} TOTAL <MonthYear> VOLUME)

Re: Preserve sum() when selecting a field

sifatnabil — Fri, 23 Sep 2016 10:54:18 GMT

Thanks - I was trying to put that set after TOTAL instead of before. Also, the legend of the bar chart still shows all 50+ clients. Is there a way to change the legend to just my client selections?

Re: Preserve sum() when selecting a field

swuehl — Fri, 23 Sep 2016 11:02:11 GMT

I can't reproduce your issue with the legend.

Could you post a small sample QVW that demonstrates this?

Re: Preserve sum() when selecting a field

sifatnabil — Fri, 23 Sep 2016 11:03:49 GMT

Actually I restricted the legend by doing dimension limits on "Show only largest 11 clients", which worked. Thanks!