Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
You don't give much to go on.
Is there any chance that you have duplicate rows in your data?
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).
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
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