topic Data filtring in QlikView

Data filtring

Wed, 27 Nov 2013 05:37:22 GMT

Hi Friends,

I have huge date in below manner, I only required the data begning with the word "Stevedorage_".

what to do ?

Item Description

RECEIVING_EXTRA GATE ALL IN USCHS PER UNIT

DELIVERY_EXTRA GATE ALL IN USCHS PER UNIT

STEVEDORAGE_ LOAD ALL IN CRCAL PER BOX

STEVEDORAGE_ DISCHARGE ALL IN CRCAL PER BOX

STEVEDORAGE LOAD ALL FULL IN PRSJU PER BOX

RECEIVING_EXTRA GATE MOVE ALL Full in USJAX by UNIT

DELIVERY_EXTRA GATE MOVE ALL in USJAX by UNIT

Re: Data filtring

Wed, 27 Nov 2013 06:10:45 GMT

hi,

wile loading all these tales use left( s , n ) function on appropriate field or column and check if that staring starts with "Stevedorage_" and load only those data.

Regards,

Abhishek

Re: Data filtring

Wed, 27 Nov 2013 06:26:34 GMT

Hi,

if your field name is [Item Description] then try this on load script:

load

From table

where [Item Description] = 'Stevedorage_*'

Hope this helps you.

Regards,

Ashutosh

Re: Data filtring

udit_kumar_sana — Wed, 27 Nov 2013 07:03:24 GMT

Hi Neeraj,

You can try like this in the script

Load

from table

where wildmatch(itemdescription ,'STEVEDORAGE_*');

Thanks & Regards,

Udit

Re: Data filtring

Wed, 27 Nov 2013 13:41:23 GMT

Use below:

LOAD * FROM table WHERE WildMatch(Fieldmatch,'Stevedorage_*');