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: 
Not applicable

Pivot Table Column with Multiple Fields

Hello Everyone,

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:

Screenshot (69).png

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:

Screenshot (72).png

But that's not quite right.

Does anyone have a good idea?

Thank you in advance,

Alison

8 Replies
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Alison,

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.

Thanks,

Arvind Patil

Not applicable
Author

Sorry, what do you mean.

My master calendar looks like this:

Screenshot (73).png

Anonymous
Not applicable
Author

Hi Alison,

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.

Regards,

Sadasiva

Not applicable
Author

Hello,

Month is the smallest unit. Attached above your post is my master calendar. That might help.

Anonymous
Not applicable
Author

Define Quarter in Master calendar as well. that may helps.

Not applicable
Author

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

Anonymous
Not applicable
Author

Have a look at this.

specific quarter dates in qlikview, - Stack Overflow

Regards,

Sadasiva

Not applicable
Author

Where I to do that, how would in influence the expression that I'd like to use in the UI?