Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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?

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.