Top N Dynamic in Qlik Sense

[vikasmahajan]

Hi all,

Attaching excel sheet with sample data I want to show top 5 dynamic , like if  user select Customer then top 5 customer , if user select top 5  Brand then it should show top 5 brand in chart.

Any idea how to achieve this in sense ?

Thanks in Adv

Vikas

[ogster1974 · Accepted solution]

Try using this technique to dynamically set your dimension with a limitation on your chart.

Makes Sense to go round in circles

[vikasmahajan]

Hi Andy

Thanks for response attaching my qvf  i am not able to see growth in dynamic chart can you please help me

Thanks

Vikas

[vikasmahajan]

Growth Nos are repeating please see attached file

[ogster1974]

I'm on my phone and out and about so won't be able to look at this any time soon.  

Anyone else help?

[OmarBenSalem]

I don't really get what u're trying to do; u have a measure; and each time u selecta dimension; u show the top5? is that so?

If that's the case; continue to do what's u're doing; just limit ur dimension:

result:

[vikasmahajan]

Thanks , I wanted to display 5 ( Sales Amt , Growth % , etc..)  top N by measure now when i select on measure then in growth % column i am getting 0.02423689281006 every row but at right side i have calculated correct growth numbers that should appear in dynamic top table.

Hope you understand now I want to show dynamic top measures on chart please see attached top chart result.png

Thanks

vikas

[vikasmahajan]

I have figure out using Makes Sense to go round in circles

Thanks

Vikas