Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

manoranjan_321988
New Contributor

Scatter Plot chart -Dynamic Selection with Top 10 and Worst 10

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 NameVolumeNet price
Acc 137,733.2837633.28
Acc 218,141.0018041
Acc 31,814.101714.1
Acc 45,830.005730
Acc 53,279.453179.45
Acc 61,457.501357.5
Acc 72,418.802318.8
Acc 818,141.0018041
Acc 923,257.5023157.5
3 Replies
Partner
Partner

Re: Scatter Plot chart -Dynamic Selection with Top 10 and Worst 10

hi 

you can use this dimension 

aggr( if (rank(sum(volume))<11 or rank(-sum(volume))<11 ,[account name]),[account name])

Highlighted
manoranjan_321988
New Contributor

Re: Scatter Plot chart -Dynamic Selection with Top 10 and Worst 10

Hi ,

its not working

its dynamic selection for the user to see the top 10 and worst 10 in the chart 

 

Partner
Partner

Re: Scatter Plot chart -Dynamic Selection with Top 10 and Worst 10

hi 

can you elaborate a little bit 

what is not working 

look at this demo 

it's will display the top 2 from the available account