topic Re: [ASK] set analysis to ignore date selection in QlikView

[ASK] set analysis to ignore date selection

Mon, 07 Apr 2014 11:50:25 GMT

Hello QlikView user..

I want to create expression with set analysis that able to ignore date selection.

so when i create an sum expression, the value will not change if i select date, but it will still change if i select another dimension.

How to do that with set analysis?

Many thx

MK_QSL — Mon, 07 Apr 2014 11:52:08 GMT

SUM({$<Date = >}Sales)

Use as above...

UPDATE :

If you want your result should not change after selecting certain dimension/field, you can use as below.

SUM({<Dimension1 = , Dimension2 = , Dimension3= >}Sales)

If you select anything in Dimension1,Dimension2 or Dimension3, your result would not change.

maxgro — Mon, 07 Apr 2014 11:53:34 GMT

date=

to disregard selection on field date

sum( {$ <date=>} expression }

very good doc on set analysis

Mon, 07 Apr 2014 12:51:34 GMT

thx before Manish..

but can i use this set analysis for one sheet?

conditional sheet or trigger perhaps?

many thx again

MK_QSL — Mon, 07 Apr 2014 12:53:31 GMT

Didn't understand your requirements ! Can you explain?