Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

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: 
daisy1438
Contributor III
Contributor III

How to create below pivot table in qliksense?

 

 

Hi Team

please find below image and is it possible to create in qliksense.

pivot.jpg

1 Reply
nisha_rai
Creator II
Creator II

Hi,

If you want to concatenate the field value, we have two way

1. Create a field in script 

Load  Country,

Concat(Distinct Sate,',') as ConbineState

From Table

Group By Country;

2. In Pivot Calculated Dimension is not working, for that you have to create a measures

Concat(Distinct Location,',')

 

May it help.