topic Re: Current selection of Set Analysis in QlikView

Current selection of Set Analysis

warrentk80 — Thu, 29 Oct 2015 09:34:59 GMT

Goodmorning everyone

I inserted a text field with a set formula analisys that should not be considered and should be independent of the selection applied on TipoAttività.

the formula is:

= sum ({1 <[TipoAttività] = {'F'}>} [Budget in €] / 1000000)

in doing so if the dashboard select the TipoAttività = 'E' text field continues to correctly display the sum of the budget for data with TipoAttività = 'F'

Syntax 1 <[....] it rules out all current selections, while I would need to consider the selection of another date field.

how can I use the setanalisys to not only consider the field selections TipoAttività? how can I add in SetAnalisys operators also control the series = CurrentSelection (Series)?

Thanks for collaboration

Andrea

Re: Current selection of Set Analysis

hic — Thu, 29 Oct 2015 09:44:46 GMT

There are two approaches:

{$<Field1=>}

will start with current selections and remove the selection in "Field1".

{1<Field2=P(Field2)>}

will start with no selections (1) and add the possible values of "Field2" in the current selection as a selection.

Note that you can have an additional Set expression inside the P() function.

HIC