topic Re: Calculate/ Show additional rows in a Pivot/Table in QlikView

Calculate/ Show additional rows in a Pivot/Table

johann_bauer — Mon, 25 Sep 2017 06:13:17 GMT

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

Johann

Re: Calculate/ Show additional rows in a Pivot/Table

marcus_sommer — Mon, 25 Sep 2017 11:00:02 GMT

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

topic Re: Calculate/ Show additional rows in a Pivot/Table in QlikView

Calculate/ Show additional rows in a Pivot/Table

EBIT %

10%

Customer return - revnue

631

Revenue %

5%

Re: Calculate/ Show additional rows in a Pivot/Table