topic Set Analysis Show Total Regardless Of Filter Selection in QlikView

Set Analysis Show Total Regardless Of Filter Selection

Fri, 22 Jul 2011 19:00:37 GMT

Hello,

Current 2010 Profit (based on any filter selection)

Sum({<Yr={'2010'}>} Profit)

I want to calculate 2010 Profit IRREGARDLESS of current Channel filter selection.

Sum({<Yr={'2010'}, Channel=>} Profit)

Question - Would my above coding do the trick (igore Channel filter selection)?

Is there better way of writing this code basically ignore ANY filter selection, except for Yr={'2010'} that I specified in the set analysis.

Your help is much appreciated!

Set Analysis Show Total Regardless Of Filter Selection

danielrozental — Fri, 22 Jul 2011 19:02:47 GMT

sure if you do

Sum({1<Yr={'2010'}>} Profit)

It will ignore all selections.

Set Analysis Show Total Regardless Of Filter Selection

Sat, 10 Sep 2011 00:30:25 GMT

I'm stuck on % of total.

In a bar chart, I have ProductGroup as dimension, and the following as expression.

Sum({<LOB={HOTEL,PKGHOTEL}>} TXN)

I would like to create another expression, which is calculating the total, IRREGARDLESS or ProductGroup.

Keep in mind, ProductGroup is the dimension slicer in this chart. Is it possible to accomplish this?

Or do I have to create a separate chart to calculate the percentage? If so, what would the set expression look like?

Your help is much appreciated!

Set Analysis Show Total Regardless Of Filter Selection

jonathandienst — Sat, 10 Sep 2011 10:00:22 GMT

The TOTAL qualifier is used to override dimensions. Use something like

Sum({<LOB={HOTEL,PKGHOTEL}>} TOTAL TXN)

You can also selectively override dimensions using TOTAL <dim1, dim2> where the dimension fields not inside the angle brackets are ignored

Hope that helps

Jonathan

Re: Set Analysis Show Total Regardless Of Filter Selection

Wed, 07 Sep 2016 18:52:07 GMT

Hi Jonathan,

This worked for me, however, I'm wondering how to limit the dimensions (within the angle brackets) to set values? I am interested in a total, but with certain dimensional fields excluded. Thanks in advance for your help.