Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

massimiliano198
New Contributor

Help me display first 3 shops based on receipts

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

   

NegozioVenditeScontrini
Aosta503
Bolzano355
Potenza294
Milano683
Rovigo551
Frosinone112
Cagliari365
2 Replies
OmarBenSalem
Esteemed Contributor

Re: Help me display first 3 shops based on receipts

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

OmarBenSalem
Esteemed Contributor

Re: Help me display first 3 shops based on receipts

If that's the case:

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

as dimension :

Negozio and put a limit :

Capture.PNG

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 :

Capture.PNG


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:

Capture.PNGCapture.PNG

Community Browser