How to create below pivot table in qliksense?

[daisy1438]

Hi Team

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

[nisha_rai]

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.