Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
johann_bauer
Partner - Contributor III
Partner - Contributor III

Calculate/ Show additional rows in a Pivot/Table

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 .

KPIMonth
Customer Return12343
EBIT313
Revenue456

EBIT %

10%

Customer return - revnue

631

Revenue %

5%

The bold ones are the calculated rows.

Thanks in advance

Kr

Johann

1 Reply
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