topic Set analysis with multiple selections and exclude in QlikView

Set analysis with multiple selections and exclude

Anonymous — Wed, 21 Sep 2016 20:07:13 GMT

Hello,

I'm trying to figure out how to include multiple selections for a dimension within set analysis while that said dimension is also being set to select excluded values.

For example, I have 2 metric fields from different tables, one is used a first metric, the other is used to view correlations.

The 2 tables or the same, as are the fields, because one is a resident of the other.

My set analysis looks like this:

Count(DISTINCT{<Account = p({$<Flag = {1}>}Account), Correlation = e(Metric)>} Account)

/ count(DISTINCT total {<Account = p({$<Flag = {1}>} Account)>} Account)

This gives me values for a list of metrics where account exist in the selected Metric, but also exist for other Metrics/Correlation dimension values.

What I'm trying to do is something like this whenever I then select a Correlation field value:

Count(DISTINCT{<Account = p({$<Flag = {1}>}Account), Correlation = {e(Metric),Correlation} >} Account)

/ count(DISTINCT total {<Account = p({$<Flag = {1}>} Account)>} Account)

This way when I select a Correlation value, the other correlation values from the chart no longer appear and the chart shrinks down to just the single line with the correlation dimension value and the % value of the correlation remain unchanged with the selection

Correlation Dimension	Total Flags	Flags per Correlation	%Correlation
Metric2	10000	9500	95%
Metric3	10000	8000	80%
Metric5	10000	200	2%

The result if I then click on Metric2 above:

Correlation Dimension	Total Flags	Flags per Correlation	%Correlation
Metric2	10000	9500	95%

Any help is greatly appreciated.

Re: Set analysis with multiple selections and exclude

sunny_talwar — Wed, 21 Sep 2016 20:12:56 GMT

How about this?

Count(DISTINCT{<Account = p({$<Flag = {1}>}Account), Correlation *= e(Metric)>} Account)

/ count(DISTINCT total {<Account = p({$<Flag = {1}>} Account)>} Account)

Re: Set analysis with multiple selections and exclude

Anonymous — Wed, 21 Sep 2016 20:24:53 GMT

That works! Thank you once again Sunny! Can you explain the '*=' to me? I haven't seen that before

Re: Set analysis with multiple selections and exclude

sunny_talwar — Wed, 21 Sep 2016 20:27:34 GMT

Asterisk is there to create a intersection between your modifier and current selection. So if nothing is selected in Correlation, your modifier will decide what needs to be shown. But if within the options that the modifier has provided you select one, the intersection will kick in and will show only the one you have selected.