topic Re: Use a date variable as a selection criterium in QlikView

Use a date variable as a selection criterium

Thu, 04 Aug 2016 11:06:43 GMT

Dear all,

I have the following data

let vFromDate = Floor (Date# ('2013-01-01', 'YYYY-MM-DD'));
let vToDate = Floor (Date# ('2016-06-01', 'YYYY-MM-DD'));

LOAD * INLINE [
    OFF_SWITCH_DAT, UVC_OMS
    4-1-2013, 12
    5-1-2013, 13
    6,1-2013, 11
];

And I have created a date slider linked to variable 'vInput1'

And now I create a straight table with the following expressions:

Count({<OFF_SWITCH_DAT ={'>=$(=Date(vInput1),'')'}>} UVC_OMS)
count({$<OFF_SWITCH_DAT_2 ={'>=$(=Date(vInput1),'DD-MM-YYYY') '}>}[UVC_OMS] )

Could anybody tell me why I still get a 0 value when I select 5-1-2013 in the date slider in the select column and 3 (so no filter) in the second one !

Re: Use a date variable as a selection criterium

maxgro — Thu, 04 Aug 2016 11:16:37 GMT

If I understand your question try with

Count({<OFF_SWITCH_DAT ={'>=$(=Date(vInput1))'}>} UVC_OMS)

your expression in image

and this is my expression

Re: Use a date variable as a selection criterium

raghvendrasingh — Thu, 04 Aug 2016 11:22:53 GMT

Hi,

May the syntax error in your load script:

LOAD * INLINE [

OFF_SWITCH_DAT, UVC_OMS

4-1-2013, 12

5-1-2013, 13

6-1-2013, 11

];

in last line After 6 there will be dash - in place of comma.

In set analysis it doesn't take any date for that condition. then it giving zero.

Thanks

Re: Use a date variable as a selection criterium

Frank_Hartmann — Thu, 04 Aug 2016 11:23:44 GMT

try:

Count({<OFF_SWITCH_DAT ={'>=$(vInput1)'}>} UVC_OMS)

hope this helps