topic Pivot Table in QlikView

Pivot Table

Wed, 07 Oct 2009 19:49:55 GMT

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

Pivot Table

Wed, 07 Oct 2009 19:52:36 GMT

Hi,

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

--Santhosh

Pivot Table

Wed, 07 Oct 2009 20:23:26 GMT

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

Pivot Table

Wed, 07 Oct 2009 21:20:49 GMT

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

Pivot Table

Wed, 07 Oct 2009 21:56:57 GMT

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