topic Re: Help!! Text object and Total Sum of Table got different result. in QlikView

Help!! Text object and Total Sum of Table got different result.

Tue, 25 Aug 2015 05:35:15 GMT

Hi,

People of Qlik Community, I was wondering why the total on my table is not equal on the text object.

the expression i use in my table is this:

sum(aggr(DISTINCT amount, payment_trn_id,business_account_no,assessment_trn_hdr_id,tax_year))

which display 20,239,370,277.03

btw, this is the expression i put on the title of the text object i use:

=num(sum(aggr(DISTINCT amount, payment_trn_id,business_account_no,assessment_trn_hdr_id,tax_year)), ' #,##0.## ')

and will display 20,239,424,681.39

any suggestion why it is not equal on the table?

Please see attachment guys,

P.S. payment_trn_id and assessment_trn_hfr_id is not included on attachment because it only connect the amount to business_account_no.

Thanks in advance !

kaushiknsolanki — Tue, 25 Aug 2015 05:52:57 GMT

Hi,

This is because of the Null values in dimensions you have used in aggregation. Also due to the dimensions you have kept in chart.

Use below expression to get the same output.

sum(total aggr(DISTINCT amount, payment_trn_id,business_account_no,assessment_trn_hdr_id,tax_year))

Regards,

Kaushik solanki

Tue, 25 Aug 2015 05:58:50 GMT

Hi Sir Kaushik,

It happen that the amount of per business_name has become 20,239,424,681.39
and I need to show individual amount per business_name.

btw, thanks for sharing