Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I group the amounts according to the bands and then filter them.
5000 <AMOUNT <10000 ---> MEDIUM
Amount> 10000 -> HIGH
AMOUNT <5000 ----> LOW
How should I do ?? An example in the image
Translated with Google Translate - Qlik Community Administrative Team
devo raggruppare gli importi secondo delle fasce e quindi filtrarli.
5000<IMPORTO<10000 ---> MEDIO
IMporto>10000 --> ALTO
IMPORTO<5000 ----> BASSO
Come devo fare?? Un esempio nell'immagine
=IF(IMPORTO>10000 ,' ALTO',if(IMPORTO<10000 AND IMPORTO>5000 ,'MEDIO',IF(IMPORTO<5000 ,' BASSO')))
=IF(IMPORTO>10000 ,' ALTO',if(IMPORTO<10000 AND IMPORTO>5000 ,'MEDIO',IF(IMPORTO<5000 ,' BASSO')))
I insert the expression =IF(IMPORTO>10000 ,' ALTO',if(IMPORTO<10000 AND IMPORTO>5000 ,'MEDIO',IF(IMPORTO<5000 ,' BASSO'))) in the screen General in the field "CAMPO".
Now the result is correct.
THANKS MIKA