topic Re: Total is not displayed in Pivot table in QlikView

Total is not displayed in Pivot table

pipuindia99 — Fri, 22 Jul 2016 06:55:54 GMT

Hi,

I have an issue, I have created a pivot table and partial sum has been checked for the Cost field. I am not getting the total though i have checked partial sum, i am getting only the label for Total and not the values.

appreciate your help in this.

Re: Total is not displayed in Pivot table

Fri, 22 Jul 2016 06:58:04 GMT

Mind sharing the QVW?

Re: Total is not displayed in Pivot table

pipuindia99 — Fri, 22 Jul 2016 07:01:10 GMT

data's are pulled from database and the size is too big to share. sorry

Re: Total is not displayed in Pivot table

kkkumar82 — Fri, 22 Jul 2016 07:07:57 GMT

Hi Prabhu,

make some selections in any of the list boxes and goto File menu -> reduce data -> keep possible values

and can upload the above file

Re: Total is not displayed in Pivot table

effinty2112 — Fri, 22 Jul 2016 07:09:23 GMT

Hi Prabhu,

Do you really want to add Actual + Budget + Variance? This will equal 2*Budget.

Cheers

Andrew

Re: Total is not displayed in Pivot table

Fri, 22 Jul 2016 07:10:49 GMT

are you added euro symbol in number tab? or it is coming form database ?

Re: Total is not displayed in Pivot table

pipuindia99 — Fri, 22 Jul 2016 07:11:30 GMT

Its something critical, which i cant share it in this. Sorry buddy

Re: Total is not displayed in Pivot table

pipuindia99 — Fri, 22 Jul 2016 07:13:42 GMT

Hi Andrew,

Yes, i really want to add all three values, whilst equal to 2*budget

Re: Total is not displayed in Pivot table

pipuindia99 — Fri, 22 Jul 2016 07:14:00 GMT

in number tab i have added

Re: Total is not displayed in Pivot table

pipuindia99 — Fri, 22 Jul 2016 07:28:11 GMT

Hi All,

Actual, Budget and Variance rows are taken as Valuelist('Actual','Budget','Variance') in dimensions.

so i think valuelist is giving problem.

Re: Total is not displayed in Pivot table

kkkumar82 — Fri, 22 Jul 2016 07:34:40 GMT

Hi Prabhu,

When you are using Valuelist, you wont get sub totals as per knowledge, faced this issue earlier.

Re: Total is not displayed in Pivot table

pipuindia99 — Fri, 22 Jul 2016 08:28:28 GMT

just now realized. is there any other way to solve this issue?

Re: Total is not displayed in Pivot table

qliksus — Fri, 22 Jul 2016 08:59:26 GMT

Is there any Custom Format done in the cell of the sub-total because it should work considering it is showing values . You can post the Expression you are using

Re: Total is not displayed in Pivot table

Fri, 22 Jul 2016 09:08:09 GMT

Possible to add the valuelist to the data table directly?

Re: Total is not displayed in Pivot table

pipuindia99 — Fri, 22 Jul 2016 09:51:15 GMT

Hi,

Are you using Valuelist in expression also?.. or only in dimension?

Re: Total is not displayed in Pivot table

qliksus — Mon, 25 Jul 2016 02:15:56 GMT

Hi ,

I am using it in Expression also

Re: Total is not displayed in Pivot table

pipuindia99 — Mon, 25 Jul 2016 08:39:47 GMT

are you using Rand() in expression? or real-time vales

Re: Total is not displayed in Pivot table

vinieme12 — Mon, 25 Jul 2016 08:41:34 GMT

You cannot use Partial Sum with ValueList as these are synthetic dimensions,

Load and Inline Table with the fieldvalues and link it to your data table,that's all you need to do

Re: Total is not displayed in Pivot table

qliksus — Mon, 25 Jul 2016 09:20:00 GMT

Hi ,

Below is the sample expression I am using

if( ValueList('Actual','Budget','Forecast')='Actual' , sum(Amt) ,

if( ValueList('Actual','Budget','Forecast')='Budget' , Sum(Amt1) ,

Sum(Amt3)

)

you can use your corresponding expression for Actual,Budget,Forecast