Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
The solution is to set the variable in the script:
SET vIgnoreDates: = Year=,Month=,Quarter=;
First solution should work
vIgnoreDates: Year=,Month=,Quarter=
And expression would be Sum({<$(vIgnoreDates)>} Measure)
Hi,
Please see the error message I got for the variable definition..
What am I doing wrong?
Thanks!
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..
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 🙂
The solution is to set the variable in the script:
SET vIgnoreDates: = Year=,Month=,Quarter=;