topic Re: Text Object Total Does not Match from Straight Table in QlikView

Text Object Total Does not Match from Straight Table

Anonymous — Fri, 21 Feb 2014 00:53:36 GMT

Hello!

Could someone figure out why my total in Text object does not match with my straight table( this is the correct total 105.8M) ?... I used a set analysis as I'm going to concatenate this with my final qvw...I don't have any issues the total value in my other Aspect item except for this 'Open PO'...I was thinking of the total mode selections like in staright table but can't find this in text object..

Anyway, I have attached the file for better understanding.

Pls. enlighten me on this..

Tks.

Re: Text Object Total Does not Match from Straight Table

Anonymous — Fri, 21 Feb 2014 02:20:55 GMT

Hi cacosta35,

Because there are multiple Due Dates for each base/mfr/mpn and you are summing distinct values, you will need to use the aggr() function to get the correct total. Try the following expression:

=money(sum(aggr(sum(DISTINCT{<Aspect={'Open PO'}>}[Total Value]),[Due Date])))

Regards,

Sean

Re: Text Object Total Does not Match from Straight Table

Nicole-Smith — Fri, 21 Feb 2014 15:23:00 GMT

=money(sum(aggr(sum({<Aspect={'Open PO'}>}distinct [Total Value]),[Base Material],MFR,MPN,[Due Date],[STD Price],[PO Value],Qty)))

Re: Text Object Total Does not Match from Straight Table

Anonymous — Fri, 21 Feb 2014 15:35:15 GMT

The results are different because the expressions are different. There is "distinct" in the table but not in the text box.

I didn't check the logic, but sum(distinct ...) is a dangerous thing. Make sure that you really need it.

Re: Text Object Total Does not Match from Straight Table

Anonymous — Fri, 21 Feb 2014 19:03:59 GMT

Thank you, Nicole...I got it it right...

Re: Text Object Total Does not Match from Straight Table

Anonymous — Fri, 21 Feb 2014 19:10:10 GMT

Thank you, Sean...Actually, there's one field (MFR or MPN ) that is missing to get the correct value..