topic Pivot table column header if there is only one expression in QlikView

Pivot table column header if there is only one expression

Tue, 15 Jul 2014 07:53:14 GMT

Hi All,

I am trying to create a pivot table with only one expression but it doesn't show the column header. However if I include another expression, the column header show up for both measures, as soon as I exclude or remove the one of the two measures and only one measure remains active in table, the header row (for measures) goes away. Any idea?

regards,

Salman

Re: Pivot table column header if there is only one expression

alexandros17 — Tue, 15 Jul 2014 07:54:25 GMT

This is the normal behaviour of pivot table ...

Re: Pivot table column header if there is only one expression

Tue, 15 Jul 2014 08:12:07 GMT

Is there a way to avoid this? Actually I have a few expressions that are enabled or disabled based on certain conditions. The table layout is best adjusted to show the headers but when there is only one expression left and headers are removed, the layout is messed up.

Re: Pivot table column header if there is only one expression

alexandros17 — Tue, 15 Jul 2014 08:24:28 GMT

Add a final column with expression: =' ' and label: make a blank space

resize it

let me know

Re: Pivot table column header if there is only one expression

Tue, 15 Jul 2014 08:50:44 GMT

Causes a think blank column in the end