Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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

Re: [ASK] set analysis to ignore date selection

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.

4 Replies
MVP
MVP

Re: [ASK] set analysis to ignore date selection

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.

MVP
MVP

Re: [ASK] set analysis to ignore date selection

date=

to disregard selection on field date

sum( {$ <date=>} expression }

very good doc on set analysis

Sets Analysis: syntaxes, exemples

Not applicable

Re: [ASK] set analysis to ignore date selection

thx before Manish..

but can i use this set analysis for one sheet?

conditional sheet or trigger perhaps?

many thx again

MVP
MVP

Re: [ASK] set analysis to ignore date selection

Didn't understand your requirements ! Can you explain?