topic Re: Create Header in Pivot Table in QlikView

Create Header in Pivot Table

Claudiu_Anghelescu — Tue, 19 Mar 2019 08:55:03 GMT

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

];

Re: Create Header in Pivot Table

Anil_Babu_Samineni — Tue, 19 Mar 2019 11:25:25 GMT

Check if that helps?

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

Re: Create Header in Pivot Table

Shubham_Deshmukh — Tue, 19 Mar 2019 11:32:29 GMT

you able to achieve this?

If yes, let me know exactly how?

Re: Create Header in Pivot Table

Claudiu_Anghelescu — Tue, 19 Mar 2019 13:27:01 GMT

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.

Re: Create Header in Pivot Table

Claudiu_Anghelescu — Tue, 19 Mar 2019 13:42:30 GMT

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

Re: Create Header in Pivot Table

Claudiu_Anghelescu — Tue, 19 Mar 2019 14:19:01 GMT

See here my work