Pivot table format - Qlik Community

chandra63 · ‎2019-09-17

Hi All,

I am having Pivot table formatting.

Cluster	HA - CY	HA - LY	SPA - CY	SPA - LY	F&B - CY	F&B - LY
Mumbai
Hyderabad

but the user wants like below.

	HA	SPA	F&B
Cluster	HA-CY	HA-LY	SPA-CY	SPA-LY	F&B-CY	F&B-LY
Mumbai
Hyderabad

Please help me to get that format.

Thanks & Regards,

Chandra.

chandra63 · ‎2019-09-17

Please find the file shown below.

please help me to get that pivot format

StarinieriG · ‎2019-09-18

Hi,

try to use a dimension like this:

=SubField(Cluster,' -',1)

Brett_Bleess · ‎2019-09-30

Chandra, not sure if the following will be of any real help or not, but I figured it was worth a shot:

https://community.qlik.com/t5/Qlik-Design-Blog/Unbalanced-n-level-hierarchies/ba-p/1474325

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.