topic Re: Where Clause in Loading in QlikView

Where Clause in Loading

uttamdwibedy — Mon, 09 Jul 2012 08:26:52 GMT

Hi EveryOne,

I want to load the specific data from a Qvd in which the Item decsription is start with "Internal" and other data which are not begin with "Internal" will not load into my model. So for this I have tried the below at the time of loading , but not worked. Pls. help me..!!

LOAD ITEM_WH,

ITEM_ID,

ITEM_CODE,

ITEM_DESCRIPTION,

FROM

(qvd) WHERE (LEFT(ITEM_DESCRIPTION,13)='INTERNAL SLOT*';

Re: Where Clause in Loading

Mon, 09 Jul 2012 08:38:17 GMT

Try

Where ITEM_DESCRIPTION like ('Internal*');

Re: Where Clause in Loading

vincent_ardiet — Mon, 09 Jul 2012 08:54:21 GMT

Hi,

Try with :

LOAD ITEM_WH,

ITEM_ID,

ITEM_CODE,

ITEM_DESCRIPTION,

FROM

(qvd) WHERE WildMatch(ITEM_DESCRIPTION,'INTERNAL SLOT*')>0;

Regards,

Vincent

Re: Where Clause in Loading

jagan — Mon, 09 Jul 2012 10:17:31 GMT

Hi,

Try like this

LOAD ITEM_WH,

ITEM_ID,

ITEM_CODE,

ITEM_DESCRIPTION

FROM

(qvd)

WHERE ITEM_DESCRIPTION LIKE 'INTERNAL SLOT*';

LOAD ITEM_WH,

ITEM_ID,

ITEM_CODE,

ITEM_DESCRIPTION

FROM

(qvd)

WHERE WildMatch(ITEM_DESCRIPTION, 'INTERNAL SLOT*');

Hope this helps you.

Regards,

Jagan.

Re: Where Clause in Loading

uttamdwibedy — Mon, 09 Jul 2012 10:18:15 GMT

Thanks a lot Dear lakhina007 and Vincent Ardiet....!!

I think Still you Persons will be there any Begnieer like me will not at trouble any time..!!

thanks again for your valuable time....!!

Re: Where Clause in Loading

Wed, 05 Aug 2015 08:00:58 GMT

can we use In clause for comparing with more than one value in place of like.

I need to use it like :

....
from
[Snapshot.qvd]
(qvd) where
date(floor([LoadDate]), 'DD/MM/YYYY') in (
SELECT fulldate FROM Date] where year(date) = YEAR(GETDATE()) )

Re: Where Clause in Loading

jagan — Wed, 05 Aug 2015 08:43:35 GMT

You can try using Match() like below

from
[Snapshot.qvd]
(qvd) where
Match(date(floor([LoadDate]), 'DD/MM/YYYY') , 'Date1', 'Date2')
SELECT fulldate FROM Date] where year(date) = YEAR(GETDATE()) )