Set analysis v Selections question

[timea21]

Hi Qlik fans,

I need your help understanding some Qlik behaviour, please.

Let's say I have the following data:

Type	Volume	ID
A	10	A123
B	20	B123
C	30	C123

And a measure as below:

sum({<Type={'A','B'}>}Volume )

Now when I make a selection on the Type to show only Type A, should my measure update to exclude B or remain to include A and B?

I have a chart where it doesn't change with the selection (as if I put {<Type=>} in there) only if I change the set analysis to an aggregated measure such as sum(aggr(sum({<Type={'A','B'}>} Volume),ID), then the selection will have an effect.

Is there any other way to ensure that my chart updates with the selections without using exclusions? I have a lot of other dimensions, so I rather list what can be included instead of what not to, while allowing users to drill down to the just one value with selections.

This didn't resolve it either: sum({<Type={'A'}>+<Type={'B'}>}Volume )

In a strange way I thought it used to work and not anymore (bug?), but I probably just didn't notice I was doing it wrong.

Thank you in advance

[marcus_sommer · Accepted solution]

You need to tell the set analysis that they should respect further selections, for example with:

sum({<Type *= {'A','B'}>}Volume )

- Marcus

[timea21]

Thank you so much! It was really doing my head in 🙂