Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
date=
to disregard selection on field date
sum( {$ <date=>} expression }
very good doc on set analysis
thx before Manish..
but can i use this set analysis for one sheet?
conditional sheet or trigger perhaps?
many thx again
Didn't understand your requirements ! Can you explain?