[ASK] set analysis to ignore date selection

[#1]

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 · Accepted solution]

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]

date=

to disregard selection on field date

sum( {$ <date=>} expression }

very good doc on set analysis

Sets Analysis: syntaxes, exemples

[#4]

thx before Manish..

but can i use this set analysis for one sheet?

conditional sheet or trigger perhaps?

many thx again

[MK_QSL]

Didn't understand your requirements ! Can you explain?