topic Re: Add to Set Analysis a variable with an expression to ignore selections in App Development

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

dafnis14 — Sat, 16 Nov 2024 19:48:20 GMT

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!

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

Anil_Babu_Samineni — Sun, 27 Oct 2019 14:49:27 GMT

First solution should work

vIgnoreDates: Year=,Month=,Quarter=

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

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

dafnis14 — Sun, 27 Oct 2019 16:21:01 GMT

Hi,

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

What am I doing wrong?

Thanks!

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

Anil_Babu_Samineni — Mon, 28 Oct 2019 00:25:36 GMT

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

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

dafnis14 — Mon, 28 Oct 2019 03:32:27 GMT

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 🙂

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

dafnis14 — Mon, 28 Oct 2019 19:03:56 GMT

The solution is to set the variable in the script:

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