Skip to main content

QlikView Connectivity

Discussion board for collaboration related to QlikView Connectors.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
chandra63
Creator
Creator

Pivot table format

Hi All,

I am having Pivot table formatting.

ClusterHA - CYHA - LYSPA - CYSPA - LYF&B - CYF&B - LY
Mumbai      
Hyderabad      

 

but the user wants like below.

                          HA                  SPA     F&B
ClusterHA-CYHA-LYSPA-CYSPA-LYF&B-CYF&B-LY
Mumbai      
Hyderabad      

Please help me to get that format.


Thanks & Regards,

Chandra.

3 Replies
chandra63
Creator
Creator
Author

Please find the file shown below.

 

please help me to get  that  pivot format

StarinieriG
Partner - Specialist
Partner - Specialist

Hi, 

try to use a dimension like this:

=SubField(Cluster,' -',1)

Brett_Bleess
Employee
Employee

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.