set analysis - multiple criteria in every chart

Fri, 08 Oct 2010 15:10:43 GMT

Hi all,

I'm finding myself using alot of set analysis to cancel out prior selections for specific charts etc.

I'm finding that there are upto 6 or 7 individual expressions that i'm having to cancel out for multiple charts. I'm having to create these same expressions in every chart or object.

Is there a quick way to apply multiple set analysis expressions to a chart rather than having to replicate them each time. Is there a way to create a 'set' of set analysis expressions that can be applied all at once.

Many thanks

Dan

set analysis - multiple criteria in every chart

pover — Fri, 08 Oct 2010 16:30:43 GMT

Dan,

Create a variable called Set_Analisis_Clear and store the part of set analysis that you repeat (In this case the variable has the value Year=). Then in the expression put expand the variable like below:

=sum({$<$(Set_Analisis_Clear),Customer={'a2i'}>} Sales)

Actually for all expressions that are repeated more then one time, it is more efficient to maintain them when you declare the expressions as variables and then expand them.

Regards.

topic set analysis - multiple criteria in every chart in QlikView

set analysis - multiple criteria in every chart

set analysis - multiple criteria in every chart