Partial Sum Charting

[tracycrown]

Dear all

Can someone help to show me an example in QV on how to chart several partial sum (ie. sub-total and grand-total) ?.

Thank you very much, Tracy

[prabhu0505]

Hi Tracy,

To achieve your expectaton, you have to use Pivot table sheet object.

Go through the Online sales example to learn more on the object.

[tracycrown]

Dear Saravana Prabhu

Yes, I know how to do it in pivot table but not Bar or Line chart, please help.

Thank you very much, Tracy

[prabhu0505]

Actually pivot table is a kind of object that is used for this purpose. But if we want to use other object then we have to cook it for our purpose.

So can you please be more specific on what is requirment?

Please explain it with an example, if possible.

[tracycrown]

Dear Saravana Prabhu

Please refer to the attached excel worksheet and questions in QV.

Thank you very much, Tracy

[tracycrown]

Dear Saravana Prabhu

Attached excel worksheet as it only allows one attachement at a time.

Thank you very much, Trac

[prabhu0505]

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/6433.Copy-of-Example_5F00_2D00_5F00_2_5F00_I-suggest.xls:550:0]

[prabhu0505]

Go through the excel, where I changed your table structure.

Comment on that.

I hope that, if you follow this format, you can achieve the reports you are looking for.

[tracycrown]

Dear Saravana Prabhu

Thanks for your quick response.

Kindly advise is there a way to do it in QV rather than rearranging excel data which is not my intention,

Thank you very much, Tracy

[#10]

Hi

If you want to have Income - COS - G&A you have to change the sign on COS and G&A values in your SQL select or load statement.

In your Chart A you have dimensions type and month, normally the total is not shown in such graphs as it will render the individual values rather small in comparison to the total.

In chart B simply remove the type-dimension to get totals per month.

For the grand total in the Pivot I only was able to create a single grand total adding a calculated dimension with the formula sum(TOTAL Data).

Regards

Jürg