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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST 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.