Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Gayathri18
Contributor II
Contributor II

Group Column Headers in pivot table

Hi. 

My requirement is, I want to display the below table into the output shown below:

Data:

Gayathri18_0-1626349292063.png

 

Output:

Gayathri18_1-1626349313853.png

 

I have searched quite a bit but the problem in my case is, there is no expression like sum/only/maxstring etc that I could use here in pivot table. Everything has to be displayed but in a different format. 

Can someone please suggest any option available in qlik? 

Note: I dont want to use textboxes because my data will change based on filters. So, would be better if it could be solved using pivot or straight tables or any other way that is possible

4 Replies
NitinK7
Specialist
Specialist

we cant do exact same

I tried more closer to your required output

NitinK7_0-1626362349459.png

 

Kushal_Chawda

@Gayathri18  one close solution would be create pivot table with below dimension and measure

Dimension:

Continent

Country

Measure:

=Concat( DISTINCT State,',')

Gayathri18
Contributor II
Contributor II
Author

Sorry for the late response. Your solution is very close to mine although not exact. Thanks for the qvw. But now, I have got a design change to add in an expression column, so working with that.

Gayathri18
Contributor II
Contributor II
Author

Sorry for the late response. Your solution is also close to mine although not exact. But now, I have got a design change to add in an expression column, so working with that.