topic Re: Re-use set analysis by replacing with a variable in QlikView

Re-use set analysis by replacing with a variable

sifatnabil — Tue, 17 Jan 2017 10:48:48 GMT

Hi all,

If I have a long set analysis that I need to repeat in many places, can I store it in a variable and use it in other expressions? It doesn't seem to work if I try this:

In script:

set setanalysis={<ABC..>};

In expression:

count($(setanalysis) Id)

This causes an error.

Re: Re-use set analysis by replacing with a variable

stabben23 — Tue, 17 Jan 2017 11:17:43 GMT

Try to enclose Your variable With '{<ABC..}'

or create the Expression inside the GUI in variable overview (Ctrl+Alt+V)

Re: Re-use set analysis by replacing with a variable

stabben23 — Tue, 17 Jan 2017 11:21:33 GMT

Read this

The Magic of Variables

Re: Re-use set analysis by replacing with a variable

sifatnabil — Tue, 17 Jan 2017 12:31:42 GMT

Thanks, the issue was that you can't put set analysis in script, as it cannot understand it -on the GUI, the variable has the phrase "Internal error" on it after reloading. Recreating the variable on the GUI fixed this.