topic Pivot table adding an expression in QlikView

Pivot table adding an expression

Wed, 03 Dec 2014 13:39:38 GMT

I have three dimensions, group, GL codes and Center, where Center is in the Horizontal axis and other two are vertical, with one expression, now if i tried to add an expression it creates another column whereas I need it to be in the dimension,

say if I need to add and expression gross contribution, I need to to be just below the Direct Variable cost as in the screen shot attached

Please help

regards

Arjun

Re: Pivot table adding an expression

yduval75 — Wed, 03 Dec 2014 13:43:08 GMT

I think it's not possible

Re: Pivot table adding an expression

JonnyPoole — Wed, 03 Dec 2014 14:03:09 GMT

Its not possible to just add it as a new row, but you can create a custom field in the data model that maps in a new dimensional value (gross contribution) and associate it through a table join to the required values.

In its simplest form , you would then add 'if () ' formulas to each expression to calculate differently depedning if its gross contribution or not.