List Box Range Values

[waqasshah]

Hi Guys,

I need your help. Actually I am trying to do display the results on the basis of List box selection.  Following is My SQL script .

CASE

when Interval BETWEEN 0 and 6 then Less then 7 days

when Interval BETWEEN '0' and 13 then Less then 14 days

when Interval BETWEEN 0 and 27 then Less then 28 days

when Interval BETWEEN 0 and 31 then Less then 30 days

The issue with the above script is it gives wrong values. Like Less then 14 Days will give you values from  7 -13 .  not  from 0-13. same like Less then 28 days  show values between 13 and 26.

My list box (please review attached picture) given me wrong data .

Is there a way I can manage in Qlikview?

Kind Regards

Waqas Shah

[Shubham_Deshmukh]

Try this :
CASE

when Interval >=0 and Interval <= 6 then Less then 7 days

when Interval >=0 and Interval <= 13 then Less then 14 days

when Interval >=0 and Interval <= 27 then Less then 28 days

when Interval >=0 and Interval <=31 then Less then 30 days

[waqasshah]

Unfortunately its not working. any other option ?

[Shubham_Deshmukh]

write it properly,

CASE
when Interval BETWEEN 0 and 6 then 'less then 7 days' //with ( ' ) after then
when Interval BETWEEN '0'  0 and 13 then 'Less then 14 days'
when Interval BETWEEN 0 and 27 then 'Less then 28 days'
when Interval BETWEEN 0 and 31 then 'Less then 30 days'

end as xyz

[waqasshah]

Sorry I did not get you . you mean trying to  add (') in SQL script ?

[Shubham_Deshmukh]

Your script : 

CASE
when Interval BETWEEN 0 and 6 then less then 7 days
when Interval BETWEEN '0' and 13 then Less then 14 days
when Interval BETWEEN 0 and 27 then Less then 28 days
when Interval BETWEEN 0 and 31 then Less then 30 days

My suggestion : 

CASE
when Interval BETWEEN 0 and 6 then 'less then 7 days' 
when Interval BETWEEN 0 and 13 then 'Less then 14 days'
when Interval BETWEEN 0 and 27 then 'Less then 28 days'
when Interval BETWEEN 0 and 31 then 'Less then 30 days'