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 !

[Digvijay_Singh]

Attaching image here..showed text box expression, the same used in table without formatting. Other than amount all fields I used as dimensions.

[krishna20]

Hi,

Please find the attached sample file.

[#4]

Hi sir krishna20,

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

[#5]

Hi Sir Digvijay Singh,

Pardon sir, I didn't get your comment, sorry for that

I already attach my work, can you please examine my work?

Thanks for helping

[Digvijay_Singh]

I am also having PE so cannot view your attachment. I just generated table using account no, name and tax year as dimensions and used your expression. We are in difficult situation as cannot view QVW of each other..

[#7]

I see, btw thanks for helping me

[krishna20]

Hi,

See the attached image

[#9]

Hi Krishna20,

Actually I don't have problem getting the amount per year, my problem is when the fields are clear, the total amount on the table is different on the text object.

btw, thank for dropping by

[krishna20]

Hi,

How much difference are you getting??

Is this the difference value 267,467.77 to chart and Text object??

In my sample i'm getting same values in chart and Text object.

[#11]

im getting 54404.35 difference in the chart and text.