topic Re: List Box Range Values in QlikView

List Box Range Values

waqasshah — Sat, 16 Nov 2024 21:20:14 GMT

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

Re: List Box Range Values

Shubham_Deshmukh — Wed, 27 Feb 2019 12:35:23 GMT

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

Re: List Box Range Values

waqasshah — Thu, 28 Feb 2019 12:47:12 GMT

Unfortunately its not working. any other option ?

Re: List Box Range Values

Shubham_Deshmukh — Thu, 28 Feb 2019 13:41:26 GMT

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

Re: List Box Range Values

waqasshah — Thu, 28 Feb 2019 15:06:12 GMT

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

Re: List Box Range Values

Shubham_Deshmukh — Fri, 01 Mar 2019 04:36:57 GMT

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'