Discussion board where members can get started with Qlik Sense.
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
You mean; you want to once show top3? and maybe after have a choice to show top 5? etc?
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