topic list box sort in QlikView

list box sort

Wed, 25 Nov 2020 16:16:04 GMT

hi every one

i have a expression list box like below :

=if(A<=5,'0-5',

if(A>=6 and A<=10 ,'6-10',

if(A>=11 and A<=15 ,'11-15',

if(A>=16 and A<=20 ,'16-20',

if(A>=21 and A<=25 ,'21-25',

if(A>=26 and A<=30 ,'26-30',

if(A>30,'>30',

)))))))

i want sort that item like

0-5

6-10

11-15

16-20

21-25

26-30

>30

please help me ..

thanks

Hamide

Re: list box sort

Chanty4u — Sun, 03 Apr 2016 06:03:19 GMT

yes... the expression is correct only

Re: list box sort

Sun, 03 Apr 2016 06:07:29 GMT

now what am i do ?

Re: list box sort

pra_kale — Sun, 03 Apr 2016 06:15:47 GMT

Hi,

You can create a field in a Data model itself say 'Bucket' and then under sort tab of List box under 'Expression' field put If condition like if(Bucket='0-5',1,if(Bucket=6-10',2 and so on. Unchecked all other sort option and just select sort Ascending from Expression.

It may helps.

Re: list box sort

settu_periasamy — Sun, 03 Apr 2016 06:16:16 GMT

Try with dual

=if(A<=5,dual ('0-5',1),

if(A>=6 and A<=10 ,dual ('6-10',2),

if(A>=11 and A<=15 ,dual ('11-15',3),

if(A>=16 and A<=20 ,dual ('16-20',4),

if(A>=21 and A<=25 ,dual ('21-25',5),

if(A>=26 and A<=30 ,dual ('26-30',6),

if(A>30,dual ('>30',7)

)))))))

Note : check the paranthesis and in the sort tab -> ascending

Re: list box sort

Sun, 03 Apr 2016 06:21:32 GMT

thanks alot