topic Where condition for single date in QlikView

Where condition for single date

Thu, 29 Sep 2011 07:49:01 GMT

In my current working QVW file having a Qvd that contains a field of "CapDateTime".

CapDateTime:

01-09-2011 01:39:40

02-09-2011 12:14:30

02-09-2011 03:24:10

03-09-2011 11:44:21

and so on...

Now

I am trying to do like below format, but it is not fetching any lines for the application.

Test1:

Load *

From C;\OrigianlData.qvd(qvd)

Where CapDateTime = 02-09-2011

;

Where i had done mistake in above script.

Thanks

Where condition for single date

SunilChauhan — Thu, 29 Sep 2011 08:06:22 GMT

Load *,

1 as junk

From C;\OrigianlData.qvd(qvd)

Where CapDateTime = 02-09-2011

while take resident it needs to add one more column

Where condition for single date

kaushiknsolanki — Thu, 29 Sep 2011 09:56:54 GMT

Hi,

Try this.

Test1:

Load *,

From C;\OrigianlData.qvd(qvd)

Where date(CapDateTime) = date(date#('02-09-2011','DD-MM-YYYY'),'DD-MM-YYYY');

Regards,

Kaushik Solanki

Where condition for single date

Fri, 30 Sep 2011 06:15:20 GMT

Hi,

You can try keeping the where clause as follows..

where date#(left(CapDateTime,10),'DD-MM-YYYY') ='03-09-2011';

Cheers.

Where condition for single date

its_anandrjs — Fri, 30 Sep 2011 06:20:02 GMT

Hi,

You have to write some thing like below

Test1:

Load *

From C:\OrigianlData.qvd(qvd)

Where Date( Left ( CapDateTime,10), 'DD-MM-YYYY' ) = ' 02-09-2011';

Which is based on your original post you miss : on that and you put ; in place of :

HTH

Rgds

Anand