Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

[ASK] set analysis to ignore date selection

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

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

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.

View solution in original post

4 Replies
MK_QSL
MVP
MVP

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
MVP
MVP

date=

to disregard selection on field date

sum( {$ <date=>} expression }

very good doc on set analysis

Sets Analysis: syntaxes, exemples

Not applicable
Author

thx before Manish..

but can i use this set analysis for one sheet?

conditional sheet or trigger perhaps?

many thx again

MK_QSL
MVP
MVP

Didn't understand your requirements ! Can you explain?