Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
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
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