Pivot Table

[#1]

Hi,

Please look at the attachment of Qlikview file and excel file. I need combination of the chart1, chart2 and chart3 into one chart. The problem is chart1 has dimension of months and country, but the chart2 and chart3 has dimension of country only. Could someone give some some suggestion on how to go with it.

Thanks

Santhosh

[#2]

Hi,

I have attached the excel sheet of how the Qlikview table should look.

--Santhosh

[#3]

Hi Santhosh,

see the attached example.

I hope it helps.

If you have a datasource which provides a date (like booking date or so) you could try to use "Set Analysis".

Good luck!

Rainer

[#4]

Hi Rainer,

Your solution looks good and as you said it is from database. I am not much aware of set analysis concept. Let me google it.

--Santhosh

[#5]

Set analysis is included from version 8.5 and I have 8,2. So, htis option is ruled out in my case.