where clause in the script

[#1]

i want to user where clause in the edit script -(3 process)

1.read from text file (date wise file 1/1/2010...10/1/2010- i want to laod only 5 to 10)

2.use date weteen clause(5-10)

3.use not exists clause to laod only (5-10)

[Miguel_Angel_Baeyens]

Hi,

I don't quite understand if you want to do all three steps, or either of any three... You can load from a text file to get only some dates using the following:

WHERE Date >= '05/01/2010' AND Date <= '10/01/2010'

Make sure the Date field is a numeric field.

Hope that helps.

Miguel

[#3]

i am new in this qlik view so i want to know how to use where clause-

1.if i am loading data from text file(date wise file stored)

2.already you explained

3.use not exist cluse(suppose i have loaded upto 4th i want to laod 5 to 10) it could be similar like 2

[#4]

please help

[#5]

Hello,

I think you need incremental load, based upon your date range.

http://community.qlik.com/message/279669#279669

Thanks,

ASINGH

[narender123]

Hi,

you can use where cluase as

eg:

Load * inline[

id,date

1,15/01/2010

2,16/01/2010

3,17/01/2010

4,18/01/2010

] where date >= '15/01/2010' and date <= '17/01/2010' ;

Not Exist:

eg:

LOAD * INLINE [

    id,name

    1, dk

    2,cck

    3,ab

    4,cd

]Where not Exists(id);

Thanks