topic Re: Issue Graph Chart - Result Sum multiplied by 2 in QlikView

Issue Graph Chart - Result Sum multiplied by 2

Black_Hole — Sat, 16 Nov 2024 01:44:53 GMT

Hello all,

I tried to calculate the amount HT for a specific value.

But, the result is multiplied by 2.

Please could you advise me what can I do to correct that.

Thank you in advance for your help.

Re: Issue Graph Chart - Result Sum multiplied by 2

m_woolf — Mon, 09 Dec 2019 16:07:30 GMT

You don't give much to go on.

Is there any chance that you have duplicate rows in your data?

Re: Issue Graph Chart - Result Sum multiplied by 2

Black_Hole — Mon, 09 Dec 2019 16:16:22 GMT

Hello @m_woolf ,

Thank you for your quick reply.

That's what, I thought at first.

So, I checked, and for some rows the calculation is correct and for some rows (like in the screen above) the result is wrong.

I don't understand...

Also, in the first table in the screen you can see that the amounts are not duplicated.

(Noted that this table contains all the fields).

Re: Issue Graph Chart - Result Sum multiplied by 2

Brett_Bleess — Tue, 17 Dec 2019 18:15:46 GMT

To Mike's point, I think in order for us to better assist you, it would be most helpful if you can attach a sample app or the real app with the issue, so folks can look at everything to try to sort out why it is occurring, bit difficult to guess with so little information.

The only thing I can offer otherwise, would be the following link to the Design Blog area of the Community, there are hundreds of how-to posts out here on different topics, you may be able to find something there to help too.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Sorry I do not have anything better, but I did notice you were using AGGR, so one thing would be the dimension(s) upon which you are aggregating may be causing things, and there are some posts on AGGR in the above link, just search on AGGR, and you should find at least a few to look over.

Regards,
Brett

Re: Issue Graph Chart - Result Sum multiplied by 2

Black_Hole — Mon, 30 Dec 2019 16:12:15 GMT

Hello @Brett_Bleess ,

Many thanks for sharing this link really useful.

Effectively, the issue is occuring due to the aggregation between my tables.

So, I will review my joins.

Kind Regards,

B.H