topic Re: How to have set analysis calculation obey current selection in QlikView

How to have set analysis calculation obey current selection

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Say I have an expression like so:

Sum({<[Type]={'A'}>}Cost)

I also have a list box for [Type]. And [Type] has A,B,C, etc. I noticed that even if I select [Type]='B' from the list box, the expression above still calculates. Is it possible to have the expression calculate a zero being that Type=A is not part of current selection?

Re: How to have set analysis calculation obey current selection

Chanty4u — Fri, 23 Feb 2018 11:22:03 GMT

may be this?

Sum({1<[Type]={'A'}>}Cost)

Re: How to have set analysis calculation obey current selection

jwjackso — Fri, 23 Feb 2018 11:45:13 GMT

Try Sum({$<[Type]={'A'}*P([Type])>}Cost)

Re: How to have set analysis calculation obey current selection

Peter_Cammaert — Fri, 23 Feb 2018 11:48:13 GMT

The set expression that you use starts from the current selection, but overrides the selection for field Type by forcibly setting it to value 'A'. By specifying the set expression [Type]={'A'}, you are effectively undoing the selection in field Type and putting a new one in place. All other current selections will remain unchanged.

To accomplish what you want, you can use combination operators like -= or *=. The latter is especally useful as it means (temporarily) assign to the field the intersection of the current selection with whatever I specify between braces. Example:

=Sum({<[Type] *= {'A'}>} Cost)

will throw away all currently selected Type values except for value 'A'. If value 'A' wasn't selected to begin with, it will stay unselected in this expression.