topic Re: total in pivot table in QlikView

total in pivot table

ssriramin19 — Mon, 31 Aug 2015 06:19:12 GMT

Below is the requirement screenshot (as from excel requirement)

Below is the actual image with the above chart created in pivot table. My question here is how to achieve the grand total in the above chart .The total portion is highlighted . the total needs to be calculated only for the mentioned columns. Total needs to be appear after the column december .How this needs to be achieved?

Can you please suggest some approach on getting this .

Re: total in pivot table

ssriramin19 — Mon, 31 Aug 2015 06:35:21 GMT

can anyone please suggest me suitable methods on how to achieve the above requirement ?

Re: total in pivot table

vikasmahajan — Mon, 31 Aug 2015 06:40:19 GMT

Refer this link try to implement the same c= a+b column total in pivot

Vikas

Re: total in pivot table

ssriramin19 — Mon, 31 Aug 2015 06:50:51 GMT

can you please elaborate a bit .I did went through the details in your requirement . But what exactly needs to be done.

Re: total in pivot table

vikasmahajan — Mon, 31 Aug 2015 06:55:13 GMT

Like a,b you have data type and this you can use for grouping and can implement the same for totaling

Viikas

Re: total in pivot table

petter — Mon, 31 Aug 2015 06:58:02 GMT

To get a total on the rightmost column you will have to go to the oresentation tab and select your month dimension and then select "sub totals on bottom".

See the attched QVW

Re: total in pivot table

ssriramin19 — Mon, 31 Aug 2015 07:03:51 GMT

but this option gives total for all the expressions. I don't want the total to be displayed for all the expression.Only for the needed (as you can see highlighted above) only for the selected columns total needs to computed.

I did tried the option in the presentation tab but that was the right requirement to replicate.

Re: total in pivot table

jagan — Mon, 31 Aug 2015 07:36:06 GMT

Hi,

For the expressions which do not want total use this expression like below

=If(RowNo() = 0, '', Sum(Sales)/Sum(TOTAL Sales))

Regards,

Jagan.

Re: total in pivot table

petter — Mon, 31 Aug 2015 08:08:17 GMT

Jagan is right you only have to put an If() expression to exclude/include the expressions you want to have totalled.

Re: total in pivot table

ssriramin19 — Mon, 31 Aug 2015 08:51:52 GMT

How this should be done?meaning I need to include the total values only for selected expression as shown above/

But this total needs to be shown after the month of december .where this expression =If(RowNo() = 0, '', Sum(Sales)/Sum(TOTAL Sales)) needs to be written?

can you clarify on this

Re: total in pivot table

jagan — Mon, 31 Aug 2015 08:55:21 GMT

Hi,

You need to give it in the expression. Suppose if you have expression like Sum(Sales) then you have to change it to =If(RowNo() = 0, '', Sum(Sales))

If not working then attach sample file, then it will be easier to understand your chart dimensions & expressions and can provide the correct solution.

Check this link for getting the solution faster

Qlik Community Tip: Posting Successful Discussion Threads

Regards,

jagan.

Re: total in pivot table

ssriramin19 — Mon, 31 Aug 2015 09:06:59 GMT

But the application size comes around 27 Mb,Actually I have placed the screen shot of the image above .One with the requirement which has the total and another is the report output screen shot. Will it not suffice?

Re: total in pivot table

jonathandienst — Mon, 31 Aug 2015 09:11:04 GMT

Screen shots help to explain the problem - they rarely help with fixing the problem.

See Preparing examples for Upload - Reduction and Data Scrambling

This will explain how to reduce the data volume (and scramble sensitive information) for upload

Re: total in pivot table

Digvijay_Singh — Mon, 31 Aug 2015 09:14:42 GMT

Like this?

Re: total in pivot table

ssriramin19 — Mon, 31 Aug 2015 09:50:56 GMT

But I tried with you approach but unable to get it correctly .

Re: total in pivot table

vikasmahajan — Mon, 31 Aug 2015 09:53:33 GMT

Better you create sample apps and attach for solution

Re: total in pivot table

ssriramin19 — Mon, 31 Aug 2015 10:03:12 GMT

The report has been attached.I need to include the total values as per below

The report needs to be referred to second tab in the attached qvw.

Please suggest an approach

Re: total in pivot table

ssriramin19 — Mon, 31 Aug 2015 10:13:12 GMT

can anyone provide me the approach on how this needs to be achieved.The actual qvw file has been attached and requirement image has been placed here.

Please do the needful on this.

Re: total in pivot table

ssriramin19 — Mon, 31 Aug 2015 12:34:14 GMT

can you please explain how to proceed further as I have pasted the qvw file and also the requirement as an image has been placed here.

Please do the needful on this