topic Re: How to show total in pivot table in QlikView

How to show total in pivot table

abc_18 — Wed, 13 May 2015 10:12:32 GMT

Hi,

I am new to Qlik View.

I have created a Pivot table , in that I want to show total value of column at last.

If I click on minimize symbol then I am not able to see total value in whole row, it will come as blank.But I want to show total at last,even if i click on ' -' symbol in pivot table

Re: How to show total in pivot table

Wed, 13 May 2015 18:04:12 GMT

not sure what u r asking?do u want t/l row to displa even when chart is minimised?

Re: How to show total in pivot table

petter — Wed, 13 May 2015 19:22:50 GMT

Could you share your application and it is much quicker for us to give you some suggestions on how to achieve it?

Re: How to show total in pivot table

Clever_Anjos — Wed, 13 May 2015 19:34:24 GMT

"Show Partial Sum" at presentation level should enable totals for each dimension

Please check your expressions, if they are aggregated, everything would be fine

Re: How to show total in pivot table

Anonymous — Wed, 13 May 2015 21:30:38 GMT

If I understand you correctly, you have values in the rows but not in total/partial total. Situation like this happens if you expression doesn't contain aggregation, for example:

Value

To make total works, expression must have aggregation, for example

sum(Value)

count(ID)

avg(Amount)

Re: How to show total in pivot table

abc_18 — Thu, 14 May 2015 04:06:10 GMT

In this example I am able to see total value at last, but if I minimize it by clicking on '-' symbol then revenue rows appears as blank.

what my requirement is ,even if I click on '-' symbol, after minimization the total value should come in Revenue row.

should not appear blank, as in second picture.

Re: How to show total in pivot table

abc_18 — Thu, 14 May 2015 04:06:40 GMT

In this example I am able to see total value at last, but if I minimize it by clicking on '-' symbol then revenue rows appears as blank.

what my requirement is ,even if I click on '-' symbol, after minimization the total value should come in Revenue row.

should not appear blank, as in second picture.

Re: How to show total in pivot table

abc_18 — Thu, 14 May 2015 04:08:24 GMT

Yes Sana.I want total row to display even when chart is minimized.

Re: How to show total in pivot table

qlikviewwizard — Thu, 14 May 2015 07:48:38 GMT

Hi shikhakumari18 ,

Try the below expression

RangeSum(Before(Sum({<Your Measure Column>), 0, 4))

Re: How to show total in pivot table

abc_18 — Thu, 14 May 2015 08:59:49 GMT

My Expression is like this.

=====================================================

=//if(([P&L Level] = 's' and [Line_No.]>=130 and [Line_No.]<=220), num((Sum({$< [Fiscal Year]={$(vFisPrevYear)},[Fiscal Month No]={"$(=vFisCurrMonth)"}>}Amount))/vMillions,'#,##0.00'))

if (match(Line_No., 320,370,380,400,410,420,430,440,450,460,470,640,650,651,652,750,760,780,790)=0,

if([BS Heading]='s',' ',num((Sum(

{$< [Fiscal Year]={$(vFisPrevYear)},[Fiscal Month No]={"$(=vFisCurrMonth)"}>}

Amount))/vMillions,'#,##0.00')),

Pick(match(Line_No., 320,370,380,400,410,420,430,440,450,460,470,640,650,651,652,750,760,780,790),

vDomesticSalariesPrev,//320

vGrossProjectMarginPrev,//370

num(vGrossProjectMarginPrev/vTotalRevenuePrev,'###.0%') ,//380

if([BS Heading]='s',' ',num((Sum({$< [Fiscal Year]={$(vFisPrevYear)},[Fiscal Month No]={"$(=vFisCurrMonth)"}>}Amount)),'#,##0.00')), //400

vBenchSalariesPrev ,//410

if([BS Heading]='s',' ',num((Sum({$< [Fiscal Year]={$(vFisPrevYear)},[Fiscal Month No]={"$(=vFisCurrMonth)"}>}Amount)),'#,##0.00')), //420

if([BS Heading]='s',' ',num((Sum({$< [Fiscal Year]={$(vFisPrevYear)},[Fiscal Month No]={"$(=vFisCurrMonth)"}>}Amount)),'#,##0.00')), //430

if([BS Heading]='s',' ',num((Sum({$< [Fiscal Year]={$(vFisPrevYear)},[Fiscal Month No]={"$(=vFisCurrMonth)"}>}Amount)),'#,##0.00')), //440

vLOBCostPrev , //450

vGrossMarginPrev , //460

num(vGrossMarginPrev/vTotalRevenuePrev ,'###.0%') , //470

vOperationMarginPrev,//640

num(vOperationMarginPrev/vTotalRevenuePrev,'###.0%') ,//650

vEBIDTAPrev,//651

num(vEBIDTAPrev/vTotalRevenuePrev,'###.0%'),//652

vPBTPrev,//750

num(vPBTPrev/(vTotalRevenuePrev+vOtherIncomePrev+vRentalIncomePrev),'###.0%'),//760

vPATPrev, //780

num(vPATPrev/(vTotalRevenuePrev+vOtherIncomePrev+vRentalIncomePrev),'###.0%'))) //790

How to get total after minimization by using this expression in Revenue row?