topic Expression duplicating the sum in QlikView

Expression duplicating the sum

Thu, 05 Nov 2015 08:40:46 GMT

Dear Expert,

Please find the attached app and screen capture on expression sum(QTY)=16 in actual records but it duplicate the record and resulting in wrong result. aggr(avg()) also result in wrong result.Also variable in set analysis not resulting properly. Help me to get proper result.

Thanks

Ashif

Re: Expression duplicating the sum

Gysbert_Wassenaar — Fri, 06 Nov 2015 13:34:47 GMT

Create a table with ZDES_DESC and QTY as dimensions and Count(QTY) and Sum(QTY) as expressions. Then tell us what the correct result should be of sum(QTY) for the dimension value ENGINEER in the dimension ZDES_DES.

Re: Expression duplicating the sum

Tue, 10 Nov 2015 07:30:05 GMT

Dear Gysbert,

Result should be one but Count(QTY) and Sum(QTY) giving wrong result.

Thanks

Ashif

Re: Expression duplicating the sum

Gysbert_Wassenaar — Tue, 10 Nov 2015 08:21:17 GMT

Count(QTY) and sum(QTY) give the correct result.

Count(QTY) is 62 for QTY value 0 because your data model has 62 records where QTY has value 0.

Count(QTY) is 250 for QTY value 1 because your data model has 250 records where QTY has value 1.

Sum(QTY) is 0 for QTY value 0 because 62 * 0 = 0.

Sum(QTY) is 250 for QTY value 1 because 250 * 1 = 250

Re: Expression duplicating the sum

Tue, 10 Nov 2015 08:32:55 GMT

HI Gysbert,

If I use Count(aggr(QTY,KEY8)) it gives proper result. So i need to review my data model once again.

Thanks Gysbert.