Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Thank you very much ¡¡, it works perfectly 😀