Hello, i am creating an app to visualize the distribution of product prices and discounts they got using scatter plot. The problem is that when there are overlapping values, the points doesn't show up at all. On the picture are three products with price of 100$ as showed in the table (dummy dataset), but they do not appear in the scatter plot. Why? Am i missing sth?
This is Qlik Sense 2019 april version. I would appreciate some input from the community!
Solved! Go to Solution.
I think you may be using Price as a dimension, in which case your data point for 100 would actually lie on 300 assuming you are using Sum as your aggregation function for measure.
That is your problem. Since you are not using an aggregation function, where there are multiple values for a dimension value, it is returned as an array of values and treated as null by the chart. Essentially it equates to using the only function.
Where there is only one value per dimension value, it will show on the chart.
Always use aggregation functions in your expressions !
Thx for understanding the situation and providing insights about how it works behind the scenes.
However, what i want to achieve is to plot the multiple values anyway, so that the client can see and select them on the scatter plot. Other corresponding diagrams (e.g. the table below) should update accordingly. Is there a way to achieve that, maybe an appropriate aggregation?
Hi Irving, that's correct. The rowno caters for situations where the price and discount are same for a client or country. You could also use the PID but as a principle it's better to use numeric fields when aggregating.
Please mark it as resolved, if it is what you are looking for.