Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

schernov
New Contributor III

Select date intervals in list box

Hi everyone,

i have table with dates, interval from 01.01.2012 to 31.12.2013,

i added 2 - variables on sheet - vStart1 , vEnd1, in this var's i put dates like this:

vStart1 = 01.10.2013

vEnd1 = 05.10.2013

i want by button click, interval of my var dates has apply to listbox

in result i want see selected dates in listbox : 01.10.2013 ,02.10.2013, 03.10.2013, 04.10.2013, 05.10.2013

in searchbox on my lisbox i can use only one condition like this >=01.10.2013 and it work's, question: how i can use second condition ?

construction not worked i've tested in

action - 'select in field' by button click:

= >=vStart1 & ' | ' & <= vEnd1

= '>=vStart1' & ' | ' & '<= vEnd1'

= (>=$(vStart1) & ' | ' & <= $(vEnd1))

construction not worked i've tested in

search field in lisbox :

>= 01.10.2013 & <= 05.10.2013

>= 01.10.2013 | <= 05.10.2013

>= 01.10.2013 || <= 05.10.2013

'>= 01.10.2013' | '<= 05.10.2013'

>= '01.10.2013' | <= '05.10.2013'

and many other's

1 Solution

Accepted Solutions
schernov
New Contributor III

Re: Select date intervals in list box

we must use select in field Search string like this:

= '>=' & vStart1 & '<=' & vEnd1

1 Reply
schernov
New Contributor III

Re: Select date intervals in list box

we must use select in field Search string like this:

= '>=' & vStart1 & '<=' & vEnd1

Community Browser