If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
please find below image and is it possible to create in qliksense.
If you want to concatenate the field value, we have two way
1. Create a field in script
Concat(Distinct Sate,',') as ConbineState
Group By Country;
2. In Pivot Calculated Dimension is not working, for that you have to create a measures
May it help.