topic Pivot table changing structure in QlikView

Pivot table changing structure

Thu, 12 Mar 2015 13:30:48 GMT

Hi all,

I have a pivot table like this (see picture):

The three columns (Actuals Amount, Budget Amount and Local Amount) are expressions that appear conditionally - I can only show each one separately, or two together, or (as on the picture) all at the same time. This is connected to a list box, where I can select Local, Budget or Actual.

My issue is, that when I only want to present one option (does not matter which one), the pivot table changes form (the Country and Period are moved to the right and are no longer above Exec IS Heading) and the labels disappear. Please see picture below:

This only happens, if I select 1 option (either Actuals, Budget or Local). If I select 2 options it works fine (see picture below):

Is there any way of preventing this?

Thank you all for your help and have a great day!!

best regards,

Jernej

Re: Pivot table changing structure

Gysbert_Wassenaar — Thu, 12 Mar 2015 17:55:59 GMT

The only thing I can think of is adding a dummy expression, resizing that to the smallest possible size and setting the text color to totally transparent.

Re: Pivot table changing structure

Fri, 13 Mar 2015 08:19:05 GMT

hi Gysbert,

thanks for your suggestion. I added a dummy expression, set the font color to match the background and an " " (empty space) as a header label and it seems to work

best regards,

Jernej