Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Valued Contributor II

Re: Pivot Table Column with Multiple Fields

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

Re: Pivot Table Column with Multiple Fields

Sorry, what do you mean.

My master calendar looks like this:

Screenshot (73).png

sadasiva
Contributor

Re: Pivot Table Column with Multiple Fields

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

Re: Pivot Table Column with Multiple Fields

Hello,

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

sadasiva
Contributor

Re: Pivot Table Column with Multiple Fields

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

Not applicable

Re: Pivot Table Column with Multiple Fields

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

sadasiva
Contributor

Re: Pivot Table Column with Multiple Fields

Have a look at this.

specific quarter dates in qlikview, - Stack Overflow

Regards,

Sadasiva

Not applicable

Re: Pivot Table Column with Multiple Fields

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

Community Browser