topic AW:Re: where statement in variable in QlikView

where statement in variable

thomaswrieck — Mon, 12 Jul 2010 09:16:02 GMT

Hi,

maybe a stupid question ... I want to store a Where clause in a variable and use it when calling a subroutine ...

LET vWhereCM = 'Vehicle.CheckInDate>=' & chr(39) & '06/01/2008' & chr(39);

That is what I have currently but the string then results as :

.Resident Summary WHERE Vehicle.CheckInDate>=''06/01/2008''

What do I need to specify to get :

Resident Summary WHERE Vehicle.CheckInDate>='06/01/2008' ?

Thanks a lot for a tip ...

Thomas

sunil2288 — Mon, 12 Jul 2010 10:24:51 GMT

HI Thomas U can try

Resident

Summary WHERE Vehicle.CheckDate<''06/01/2008'' or Vehicle.CheckDate=''06/01/2008''

brenner_martina — Mon, 12 Jul 2010 10:38:02 GMT

Hi, Thomas,

I would prefer to use the num-function for dates, than you don't need quotes for numbers, here the variables would be like this:

New variable for numeric date:

LET vNumDate = Num(Datefield); or LET vNumDate = Num(Makedate(2008,1,6));

LET vWhereCM = 'Num(Vehicle.CheckInDate)>=' & $(vNumDate) ;

thomaswrieck — Mon, 12 Jul 2010 12:10:49 GMT

great .. thanks a lot ... that one worked for me ...

LET vNumDate = Num(Makedate(2008,1,6));

LET vStartDate = 'Num(Vehicle.CheckInDate)>=' & $(vNumDate) ;