Total Incorrect In Qlik View Pivot

[pranali_gawde]

Hi All,

I am trying to calculate total difference in  qlikview pivot against 5 dimension one is column and four in rows.

Total is coming for whichever row contain only one value in the column not for others.Below is the screenshot attached.

Kindly help to resolve this.

[sunny_talwar]

What is your expression?

[pranali_gawde]

=if(Dimenstionality()<=4,count({<Test_Group={'Benchmrking','industrialization','Design','Mold','Marketing'}>} if(daydiff>0,daydiff))&'-'&

count({<Test_Group={'Benchmrking','industrialization','Design','Mold','Marketing'}>} if(daydiff<0,daydiff))

,only({<Test_Group={'Benchmrking','industrialization','Design','Mold','Marketing'}>} daydiff))

[pranali_gawde]

if( Dimensionality()<=4,count({<Test_Group={'Benchmrking','industrialization','Design','Mold','Marketing'}>} if(daydiff>0,daydiff)) &'-'&

count({<Test_Group={'Benchmrking','industrialization','Design','Mold','Marketing'}>} if(daydiff<0,daydiff)),

only({<Test_Group={'Benchmrking','industrialization','Design','Mold','Marketing'}>} daydiff))

[sunny_talwar]

May be you need Sum() instead of Only?

=If(Dimenstionality() <= 4, Count({<Test_Group = {'Benchmrking', 'industrialization', 'Design', 'Mold', 'Marketing'}>} If(daydiff > 0, daydiff)) & '-' & Count({<Test_Group = {'Benchmrking','industrialization','Design','Mold','Marketing'}>} If(daydiff < 0, daydiff)), Sum({<Test_Group = {'Benchmrking','industrialization','Design','Mold','Marketing'}>} daydiff))

[pranali_gawde]

Yes ,Sir it's working.

Thank you so much.