How to show total in pivot table

[abc_18]

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

[#2]

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

[petter]

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

[Clever_Anjos]

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

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

[Anonymous]

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)

[abc_18]

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.

[abc_18]

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.

[abc_18]

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

[qlikviewwizard]

Hi shikhakumari18 ,

Try the below expression

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

[abc_18]

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?