Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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
example: