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 02:47:06 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 !

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

settu_periasamy — Tue, 25 Aug 2015 02:54:21 GMT

Hi,

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

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

Tue, 25 Aug 2015 03:07:29 GMT

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.

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

jagan — Tue, 25 Aug 2015 03:18:14 GMT

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.

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

Tue, 25 Aug 2015 03:43:26 GMT

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?

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

jagan — Tue, 25 Aug 2015 03:51:00 GMT

Hi,

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

Regards,

Jagan.

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

Digvijay_Singh — Tue, 25 Aug 2015 05:22:53 GMT

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.

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

Digvijay_Singh — Tue, 25 Aug 2015 05:26:23 GMT

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.

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

Tue, 25 Aug 2015 05:30:10 GMT

Hi Sir Digvijay,

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

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

Tue, 25 Aug 2015 05:34:10 GMT

Hi Sir Jagan,

Please see attachment, Thanks

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

Digvijay_Singh — Tue, 25 Aug 2015 05:43:03 GMT

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

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

krishna20 — Tue, 25 Aug 2015 05:59:44 GMT

Hi,

Please find the attached sample file.

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

Tue, 25 Aug 2015 06:01:47 GMT

Hi sir krishna20,

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

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

Tue, 25 Aug 2015 06:06:53 GMT

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

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

Digvijay_Singh — Tue, 25 Aug 2015 06:19:05 GMT

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..

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

Tue, 25 Aug 2015 06:26:59 GMT

I see, btw thanks for helping me

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

krishna20 — Tue, 25 Aug 2015 06:40:32 GMT

Hi,

See the attached image

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

Tue, 25 Aug 2015 06:50:28 GMT

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

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

krishna20 — Tue, 25 Aug 2015 06:55:58 GMT

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.

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

Tue, 25 Aug 2015 07:03:42 GMT

im getting 54404.35 difference in the chart and text.