Discussion board where members can get started with Qlik Sense.
Sorry for the bad discussion title, I wasn't sure what name to give it.
Anyway, I would like to make a table that looks like this:
Where, for each quarter, there is a column for Actual, Budget and the Variance.
The only difficult is that Q1 Project Budget, Q2 Project Budget, Q3 Project Budget and Q4 Project Budget are all different fields.
How could I make so that, depending on the Quarter, a different field and thus a different quarter budget is displayed.
I tried to use the following expression:
But that's not quite right.
Does anyone have a good idea?
Thank you in advance,
If you have generated master calendar for budget also means Budget date include in master calendar.
Write normal expression and drag the quarter column above.
Sorry, what do you mean.
My master calendar looks like this:
Need some clarity on your data..
What level you are mapping your data(Actual and budget)(Date level mapping/week level/month level/Quarter level). If you are mapping at same level then this issue will be solved.
Month is the smallest unit. Attached above your post is my master calendar. That might help.
Define Quarter in Master calendar as well. that may helps.
Thank you for your suggestion but I am not really sure how to do that as I quarters do not follow the calendar year. They are as follows:
Q1: 08-2016 - 10-2016
Q2 : 11-2016 - 01-2017
Q3 : 02-2017 - 04-2017
Q4: 05-2017 - 07-2017
Have a look at this.
specific quarter dates in qlikview, - Stack Overflow
Where I to do that, how would in influence the expression that I'd like to use in the UI?