Create Header in Pivot Table

[Claudiu_Anghelescu]

Hello,

I want to create some headers  A, B and C like below in a Pivot Table.

I tried using ValuesList() but this function duplicate the Expressions A1, A2, A3, A4, A5 also under the header B.

So I will have the same structure in mirror for every header.

Also I tried using a fake table to group into dimensions my fields; here the problem it's different, seems to be ok but I cannot Suppress the NULL columns which are duplicated under other header.

LOAD * Inline [

A, B, C

A1, B1, C1

A2, B2, C3

A2, B3, C3

];

[Anil_Babu_Samineni]

Check if that helps?

https://community.qlik.com/t5/New-to-QlikView/is-this-possible-in-Pivot/m-p/1557064#M371752

[Shubham_Deshmukh]

you able to achieve this?

If yes, let me know exactly how?

[Claudiu_Anghelescu]

Unfourtunately no.
I made something with a single Expression and a nested IF but being a single Expression I'm not able to put conditional colors for each column.

[Claudiu_Anghelescu · Accepted solution]

I did it, but in the same Expression all the columns.
I will make a Document with samples and I will share it here.

[Claudiu_Anghelescu]

See here my work