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

[#1]

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 !

[settu_periasamy]

Hi,

Did you try this, Instead of Expression Total, Try the Sum in Total Mode (Expression Tab)

[#3]

I try what you suggest sir but still the result on the table is 20,239,370,277.03.

I think the problem is in the text object.

[jagan]

Hi,

If you select Sum of Rows in Expression and if you use the same expression in Text object then the values should match.

Also check whether you had selected Supress When Value is Null option in Dimension tab for the dimension?  If yes then you have to remove this to match.

Regards,

Jagan.

[#5]

Hi Sir Jagan,

Thanks for the advice but the result is the same, nothing change, but every time i select the year the result in the Text Object is equal to the result on the table.

any suggestion why this is happening?

[jagan]

Hi,

If possible attach sample file, it is easier to fix.

Regards,

Jagan.

[Digvijay_Singh]

I tried to replicate with excel data, please see attached, not sure why it is showing double amount to the figure you have mentioned but it is showing same value in table and text box. I removed the fields from expression which are not available in excel as without removing I cannot generate the chart.

[Digvijay_Singh]

I just realised that your text box expression has formatting over and above, after applying that as well I see the same amount with only difference after decimal due to rounding to 2 places.

[#9]

Hi Sir Digvijay,

My Qlikview has exceeded the maximum number of document recoveries, I can't view what who have done

[#10]

Hi Sir Jagan,

Please see attachment, Thanks