topic Re: Filter by date variable in load statement in QlikView

Filter by date variable in load statement

Fri, 08 Nov 2013 10:27:01 GMT

Hello,

I am trying to load in data based on the date variable created using calendar object (in DD/MM/YYYY format). The date in the database (MS Access) is also in the short format.

When I try to select the date from the calendar object & trigger reload , I am unable to load the extract the data based on the selected date.

However it works using today function as below

LOAD Account,Currency, Cal_date Where Match(Date(Cal_date),date(today()));

SQL SELECT Account,Currency, Cal_date FROM `Currentdata` ;

Can someone help me in the resolving it ?

LOAD Account,Currency, Cal_date Where Match(Date(Cal_date),vdate);

SQL SELECT Account,Currency, Cal_date FROM `Currentdata` ;

( note : vdate is the variable created in QV and linked to the calendar object, i tried using $vdate and &vdate it does not work.)

regards,

Kamal

Re: Filter by date variable in load statement

bruno_m_santos — Fri, 08 Nov 2013 10:40:00 GMT

Try $(vdate)

Re: Filter by date variable in load statement

Gysbert_Wassenaar — Fri, 08 Nov 2013 10:42:18 GMT

Try '$(vdate)'

Re: Filter by date variable in load statement

bruno_m_santos — Fri, 08 Nov 2013 10:42:43 GMT

If you pute =$(vdate) in a text box , what value is displayed?.

Re: Filter by date variable in load statement

Fri, 08 Nov 2013 10:45:35 GMT

Hi Bruno, I tried it but does not work.

Thinking some format issue, because if I use '08/11/2013' it works but using $(vdate)

Any other options ?

thanks in advance, Kamal

Re: Filter by date variable in load statement

Fri, 08 Nov 2013 10:50:04 GMT

Thank you Gysbert and Bruno.. it worked now

Re: Filter by date variable in load statement

Fri, 08 Nov 2013 10:57:45 GMT

Hi Kamal,

You are saying you create vdate when creating the calendar table? I'm just thinking vdate might not exist yet in the case you have the mastercalendar creation in the end of the script.

Otherwise I would create two new fields in the sam table, one with result of Date(Cal_date) and one with $(vdate) and check if the format seems to match.

BR,