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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
asknyldz
Contributor III
Contributor III

Pivot Table Expressions

Hi there,

I want to add "Actual vs Budget" Expression in this pivot table. How can i do this?

Labels (1)
3 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Use two expressions on a table/chart with MONTH as a dimension:

Sum({<TYPE = {ACTUAL}>} AMOUNT)

Sum({<TYPE = {BUDGET}>} AMOUNT)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
jonathandienst
Partner - Champion III
Partner - Champion III

Or use the expression Sum(AMOUNT) with MONTH and TYPE as dimensions

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable

Hi,

Please find attached application for your info.