Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
HI @justISO
Thanks for your reply. I am not aggregating anything. It's just sum(stock) and Level 5.
Any suggestions please?
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
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.
Hi
I tried both and it isn't working 😞