Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table adding an expression

Hi

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

2 Replies
yduval75
Partner - Creator III
Partner - Creator III

I think it's not possible

JonnyPoole
Former Employee
Former Employee

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.