topic Re: Set Analysis setence store into a variable? in QlikView

Set Analysis setence store into a variable?

EdgarMM — Tue, 14 Apr 2020 20:27:17 GMT

Hi there:

I'm pretty new in Qlikview and I'm trying to store a hole set analysis sentence into a variable and use this variable into several graphs and pivot tables; the objective of this is only to change the content of the variable and not to change the graphs or the dynamic tables every time a change is required; is there a way to do it or it is only posible store part of the set analysis sentence into the variable?

Example:

What I want to store but it does not work:

vMXAct = sum({$<[Source]={'Actual'}, [Country]={'MX'}>} AMOUNT)

The only way I found it works is like this:

VMXAct = [Source]={'Actual'}, [Country]={'MX'}

In the graphs and pivote tables:

=Sum({$<$(=vMXAct)>} AMOUNT)

Thanks in advanced for your help.

Regards,

Edgar.

Re: Set Analysis setence store into a variable?

Vegar — Tue, 14 Apr 2020 20:38:52 GMT

Consider this script:

SET vMXAct = sum({$<[Source]={'Actual'}, [Country]={'MX'}>} AMOUNT);
LOAD * inline [
Source, Country, AMOUNT
Budget, MX, 100
Actual, MX, 110
Budget, SE, 90
Actual, SE, 95
];

It will give this output:

See attached qvw

Re: Set Analysis setence store into a variable?

EdgarMM — Tue, 14 Apr 2020 20:58:34 GMT

Thank you very much ¡¡, it works perfectly 😀