topic Re: Overview in Pivot Chart in QlikView

Overview in Pivot Chart

tamilarasu — Tue, 10 Feb 2015 15:59:22 GMT

Hi Guys,

I need your help on creating pivot chart. Is it possible to create a chart like below screenshot. I am stuck on this as I am new to qlikview

I have attached sample file.

Many thanks in advance

Regards,

Tamil

Re: Overview in Pivot Chart

Tue, 10 Feb 2015 16:54:39 GMT

Hi Tamil,

I think you cannot create a chart exactly like shown above. But you can use Pivot Table to show Region and Country(by adding as dimensions) and Overall in CHF,Overall in USD and Total (adding as expressions). But still you cannot show these headings as labels in Pivot Chart.

Re: Overview in Pivot Chart

tamilarasu — Tue, 10 Feb 2015 17:09:06 GMT

Hi Krishna,

That's not a problem. I need to show sub totals for region wise and over all total. Can you tell me how to do. Ill give a try.

Re: Overview in Pivot Chart

Tue, 10 Feb 2015 17:16:36 GMT

Can you provide me with the sample data or attach .qvw you are using it would be easier to show you.The attached samp.qvw is not a relevant one.

Re: Overview in Pivot Chart

tamilarasu — Tue, 10 Feb 2015 17:30:14 GMT

Here it is. I have added short names for countries. I have multiple excel files, so only I have attached .qvw file. Hope this is okay for you.

Re: Overview in Pivot Chart

Tue, 10 Feb 2015 18:01:51 GMT

Tamil,

Attached is the solution for your problem. Hope this helps. Here is also a screenshot.Please mark this thread as answered if this solution works for you.

Note: Check Partial sums for the dimensions'Region' and 'CountryName' in presentation tab.

Thanks

Re: Overview in Pivot Chart

tamilarasu — Tue, 10 Feb 2015 18:11:32 GMT

Hi Krishna,

Perfect!! I have removed the vCurrency header from the dimensions and the output is exactly what I was looking.

Re: Overview in Pivot Chart

Tue, 10 Feb 2015 18:17:46 GMT

Thanks for the emoticon. Happy to know the solution worked for you.