Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.
Thanks, had to prebuild the dimensions then use your suggestion as the measures. Works as intended.