Help me display first 3 shops based on receipts

[Anonymous]

Hi everybody, can you please help me with an issue? I have this table and I'd like to display the first 3 shops only cause they've the higher receipts. I just need to display a parametric selection, not a fix one

Negozio	Vendite	Scontrini
Aosta	50	3
Bolzano	35	5
Potenza	29	4
Milano	68	3
Rovigo	55	1
Frosinone	11	2
Cagliari	36	5

[OmarBenSalem]

You mean; you want to once show top3? and maybe after have a choice to show top 5? etc?

[OmarBenSalem]

If that's the case:

create a chart (bar/table, whatever u want);

as dimension :

Negozio and put a limit :

as a measure: sum( Vendite)

this will show only the top 3.

Now, if u want to have control on the top n u wnt to show; please download this extension:

GitHub - LorisLombardo87/sense-input-variable: Sense Input Varible

(unzip it and put it under, documents/qlik/sense/extensions..

and create a variable vTop; give it value 3

and in the extension; call the vTop variable :

and in ur dimension; instead of fixating the number to 3 like in the first screenshot; call $(vTop)

with that, each tme u enter a new number; top yourNumber will be shown

example: