Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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?
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 ?
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
You can aggregate the sum(dimension) by Country, product, date