Calculate/ Show additional rows in a Pivot/Table

[johann_bauer]

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

[marcus_sommer]

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