Overview in Pivot Chart

[tamilarasu]

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

!

[#2]

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.

[tamilarasu]

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.

[#4]

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.

[tamilarasu]

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.

!

[#6 · Accepted solution]

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

[tamilarasu]

Hi Krishna,

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

[#8]

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