I need to create a pivot table similar to excel

[Anonymous]

Need to cerate a pivot table like the below example. The pivot table in QlikView looks different. Not able to add 'county' as the column. Any suggestions ?

[sunny_talwar]

Why are you not able to add County as column? Is this how the raw data look like? May be you need to use CrossTable load and then use the new County column as one of the dimension and pivot it?

The Crosstable Load

[Anonymous]

‌Hey Sunny,

thanks for the response.  My raw data is the other way ..  Date, Product and Country.  Three fields in the raw data table.  But I have to create a pivot table in QlikView like the above. Any suggestions ?

[sunny_talwar]

So I guess all you need to do is to pivot your Country dimension. See here on how you can do that

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Pivot_Table.htm‌

Shows an example under 'Using the Pivot table' header

[#5]

You can aggregate the sum(dimension) by Country, product, date