Hi all,
I have data of example below, in this data we have almost more accounts example 800 or N numbers.
So in my scatter chart i can't show all the 800 accounts since it will look busy , so my new requirement is that user want to make dynamic selection only with best 10 & worst 10 in the chart in this chart. pls let me know how achieve this in qliksense scatter chart.
Dim as Account name
x axis as sum(volume)
Y axis as sum(Net Price)
| Account Name | Volume | Net price |
| Acc 1 | 37,733.28 | 37633.28 |
| Acc 2 | 18,141.00 | 18041 |
| Acc 3 | 1,814.10 | 1714.1 |
| Acc 4 | 5,830.00 | 5730 |
| Acc 5 | 3,279.45 | 3179.45 |
| Acc 6 | 1,457.50 | 1357.5 |
| Acc 7 | 2,418.80 | 2318.8 |
| Acc 8 | 18,141.00 | 18041 |
| Acc 9 | 23,257.50 | 23157.5 |
