Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
richard_cioci
Contributor

Keeping the pivot table columns/structure the same

Hi All,

I have a pivot table showing financial data for Business Units (1st column) and expanding into Cost Centres (2nd column). As you can see to the right, I have many expressions which I've organized according to actuals, or part of the first forecast, or part of the outer years, as shown by the colours. These coloured headers are just text boxes which I've created, because it seemed the most practical way to do this. (I've looked up doing double headers in qlik but it seems very complicated and only if you can do the setup when you're loading the script as you're basically calculating the values and creating new dimensions for those expressions, however my dashboard allows them to change the reporting date so that all the shown values change, which won't work if I set values in the load script for each expression to be a dimension)

You can see my pivot here:

Capture.PNG

Anyway, my issue is that higher level managers will need to collapse all the business units to see the totals as a whole, and when it does that, the Cost Centre column disappears and the whole pivot table shifts over like this:

Capture.PNG

As you can see, now the labels are all incorrect.

Is there a way to make the structure of the pivot permanent, so that even if they collapse franchise units, it will remain the same? Always fully expanded does not solve this as they need to still be able to collapse the Cost Centre dimension.

Thoughts?

1 Solution

Accepted Solutions
Highlighted
antoniotiman
Honored Contributor III

Re: Keeping the pivot table columns/structure the same

Hi Richard,

this is the best I can do.

See Attachment.

Regards,

Antonio

View solution in original post

3 Replies
Highlighted
ariel_klien
Valued Contributor

Re: Keeping the pivot table columns/structure the same

Hi,

can you attach a sample of the model?

Ariel

Highlighted
antoniotiman
Honored Contributor III

Re: Keeping the pivot table columns/structure the same

Hi Richard,

this is the best I can do.

See Attachment.

Regards,

Antonio

View solution in original post

Highlighted
richard_cioci
Contributor

Re: Keeping the pivot table columns/structure the same

Don't know why I didn't think of this. I use variables like this for so many other work-arounds. Thanks, I think this is likely to be the least complicated solve.

Cheers