Add to Set Analysis a variable with an expression to ignore selections

[dafnis14]

Hi,

I would like to add to a Set Analysis expression a variable which holds a string for ignoring selections:

vIgnoreDates: Year=,Month=,Quarter=

Trying to create the variable in Sense with the above generates an error.

Tried the following syntax: 'Year=,Month=,Quarter='

but the selections are not ignored.

Any Idea how to use a variable for a part of a Set Analysis expression ?

Thanks!

[Anil_Babu_Samineni]

First solution should work

vIgnoreDates: Year=,Month=,Quarter=

And expression would be Sum({<$(vIgnoreDates)>} Measure)

[dafnis14]

Hi,

Please see the error message I got for the variable definition..

What am I doing wrong?

Thanks!

[Anil_Babu_Samineni]

That is qlik error as part of bug. Just ignore this and try in set analysis. Even in set analysis, you will get the error syntax. So simply ignore there and do apply and then check will see..

[dafnis14]

The thing is, unlike QlikView, you can't save a variable with a bad expression.

At least, I didn't succeed...

Thanks for trying to help 🙂

[dafnis14 · Accepted solution]

The solution is to set the variable in the script:

SET vIgnoreDates: = Year=,Month=,Quarter=;