Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I think this should be an easy thing to do but im kinda struggling with that.
So lets say for example. I have following Rows in my source data (qvd)
and i want to show them in a pivot and additionaly calculate some rows.
BTW its qlik sense, but i think i doesnt matter .
KPI | Month |
---|---|
Customer Return | 12343 |
EBIT | 313 |
Revenue | 456 |
EBIT % | 10% |
Customer return - revnue | 631 |
Revenue % | 5% |
The bold ones are the calculated rows.
Thanks in advance
Kr
Johann
You need to add these dimension-values to your dimension. This could be done with a calculated dimension, for example with valuelist() but better would be to add these values within the script, maybe with a small inline-load like:
concatenate(YourTable)
load * inline [
KPI
EBIT%
...
];
and then you could query this dimension-value with an expression like:
pick(match(KPI, 'Customer Return', ...)
expr1,
expr2,
...)
- Marcus