Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
4ldchestn
Contributor
Contributor

Qliksense - Table with Actual vs Budget Month over Month

Hi,

 

I am trying to create a table in QlikSense that displays actual and budget measures month over month with variance. Attached is an example. Where do I start?

1 Solution

Accepted Solutions
jwjackso
Specialist III
Specialist III

Use a pivot table with accounts as the dimension and the time period as the column.  You will have 3 measures, sum(actuals), sum(budget) and either (sum(actuals)-sum(budget)) or (sum(budget)-sum(actuals)) depending on the account type.

View solution in original post

2 Replies
jwjackso
Specialist III
Specialist III

Use a pivot table with accounts as the dimension and the time period as the column.  You will have 3 measures, sum(actuals), sum(budget) and either (sum(actuals)-sum(budget)) or (sum(budget)-sum(actuals)) depending on the account type.

4ldchestn
Contributor
Contributor
Author

Thanks, had to prebuild the dimensions then use your suggestion as the measures. Works as intended.