Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have a weird one.
So I am building a straight table.
In this table 1 dimension is acting really weird.
So I need to display the weight that came from the field (gem_gewicht)
But because one dimension has 2 same values but not in every dimension, it adds up the numbers automatically.
And it should just display the true value coming trough based on the article.
I provided a picture. the result for the selection on the collumn (gewicht) should be half of what it is displaying.
any ideas?
Hello,
First of all, thank you for the reply.
Secondly, the "gewicht" vale is a value that comes from the database. It is an absolute field that doesn't require calculation. In the database this field displays the weight of a certain product (Artikel). That weight has to be displayed in the table as I mentioned before. Right now what happen is, Qliksense finds 2 "Artikel" fields with the same value and adds up the weight. For example: If the weight of Product A = 1.02. We sort on level "niveau", product A is found on level 1 and level 0. So 2 fields with the same value. Qliksense interprets this and adds up the values. Wich means Product A is displayed twice, once with level 1 en once with level 0. However the weight of each is now 2.04. So there is an add up of this value because it is double. That shouldn't happen. Qliksense should display the absolute weight of the product, even if the Product shows up twice.
Hopefully this explains it a bit more.
I reattached the sample for reference. Now the weight is 1.09, but it should be half.
Hello,
I think I'm having the same issue, no idea why. This table is sourced from an xlsx file and is exactly equal to the first three columns of the file (fourth column is the QS sum). Why the hell does it double up? Any idea?
Thanks!
Found my error: somehow, I had duplicated part of my load script.