topic Re: Total Incorrect In Qlik View Pivot in QlikView

Total Incorrect In Qlik View Pivot

pranali_gawde — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Total Incorrect In Qlik View Pivot

sunny_talwar — Fri, 22 Jun 2018 16:14:34 GMT

What is your expression?

Re: Total Incorrect In Qlik View Pivot

pranali_gawde — Sat, 23 Jun 2018 07:55:50 GMT

=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))

Re: Total Incorrect In Qlik View Pivot

pranali_gawde — Sat, 23 Jun 2018 08:14:32 GMT

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))

Re: Total Incorrect In Qlik View Pivot

sunny_talwar — Sun, 24 Jun 2018 11:47:34 GMT

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))

Re: Total Incorrect In Qlik View Pivot

pranali_gawde — Mon, 25 Jun 2018 06:15:30 GMT

Yes ,Sir it's working.

Thank you so much.