Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
malradi88
Creator II
Creator II

Variance Column for a Budget

Dear Qlik Community,

I am trying to work out how to create a variance column in a table. So if you select Jan, Feb and Mar, I would like that to be compared to the Q1 Budget and display how much the spending went over or under. And if you select Apr, May, June I want that to be compared to Q2 budget and so on...

To my untrained eyes, that seems quite complicated but I assume that it must be possible and that others have wanted to do similar things.

I have attached an app that I made for these purposes so, if possible, please can you demonstrate the solution on the app.If not any feedback or tips would be much appreciated!

Best,

Mohammed

0 Replies