Find distinct value when ID is the same

[qlikuser22]

Hi,

I am still a newbie to qlik. I am having a trouble in finding distinct value when the ID is the same for two columns. I am trying to build some hierarchy table where I have several products and their hierarchy with a unique ID. 

I am trying to create a chart which shows the Level 5 with Stock. 

But my graph looks like this. 

I would like to see the Level 5 graph as 10100, 10100 and 10101. 

Please help

Thanks in advance!

[justISO]

Hi, in your chart measure, are you aggregating something? If your provided sample represent your actual data structure, simple bar chart with dimension [Level 5] and measure as sum([Stock]) would work as you need.

[qlikuser22]

HI @justISO 

Thanks for your reply. I am not aggregating anything. It's just sum(stock) and Level 5.
Any suggestions please?

[vinieme12]

can you post a snapshot of your data model?  

simply using , below would render the desired chart,

Dimension

=Level5

Measure

=sum(Stock)

UNLESS 

1) you are using the TOTAL keyword

sum(TOTAL stock)

2) Your Stock data is not associated to Level5 correctly

and I'm assuming its  point no2

[justISO]

so if you are using just sum(stock) and [Level5] and getting 30k instead 10k, most probably that you have 3 lines of same level 5 item name. You can try change measure to

Sum(aggr(Stock, [Level5]))

or change dimension to something like

[Unique ID]&[Level5]

and try to find what approach can distinct your rows to get correct stock.

[qlikuser22]

Hi 

I tried both and it isn't working 😞