Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Manuel06
Contributor
Contributor

Same value in columns for different rows

Hi all!

I'm very new to Qlik Sense and am already running into some -I believe- basic issues. 

How come my data is the same in every row for a certain column, although every product in the row is different?

I know that the values represented are impossible, and also that my input data is correct. I've been battling with this for days now and can't get it right. Hope there's someone who might shed some light on this matter.

Utilisation pic 1.PNG

Note: I still want the sum of all the individual, expanded rows (so the fat marked text should be the sum of all the values underneath it).

Utilisation pic 2.PNG

Thanks in advance,

Kind regards

Manuel

Labels (3)
2 Replies
Channa
Specialist III
Specialist III

try to review you joins

since ur using SUM() it should not repeat

there should some issues with your JOINS
Channa
Manuel06
Contributor
Contributor
Author

That was the problem indeed! Thank you very much!