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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Variance Column

Hi All,

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.

Thank you all very much in advance,

Alison

1 Reply
megan_deboer
Partner - Contributor II
Partner - Contributor II

Hi Allison,

I'm searching to find a solution to this same issue. Where you able to find a solution?

Thanks, Megan