Selecting One year Data while loading

[Anonymous]

Hi,

Iam new to Qlikview

Here I have a small doubt that

I have On date filed like In_date which consisting of 2013,2014 data. But while loading the data i need to load only 2014 data.

Is there any possibility for this.

Here am attaching my sample excel sheet

Please help me ..

Thank you,

Amarnath

[#2]

Hi Amarnath,

While loading data in edit Script you can load data use where Condition use year that data only will load

Like where Year = 2014.

Ramya.

[sunilkumarqv]

MaterCalender:

LOAD Victim_id,

     Name,

     Date_of_birth,

     [Name _of_guardian],

     Gender,

     Phone_no,

     Address,

     status,

     In_date,

     Out_date,

     Condition

FROM

MasterCalendar.xlsx

(ooxml, embedded labels, table is Sheet1) where In_date<='31/01/2014';

[MK_QSL · Accepted solution]

LOAD Victim_id,

     Name,

     Date_of_birth,

     [Name _of_guardian],

     Gender,

     Phone_no,

     Address,

     status,

     In_date,

     Out_date,

     Condition

FROM

MasterCalendar.xlsx

(ooxml, embedded labels, table is Sheet1)

Where Year(In_date)=2014;

[MayilVahanan]

Hi

Try like this

Load * from datasource

Where Year(In_date)=2014;

[Anonymous]

Hi Ramya,

Thank you for you reply but In_date consists the data like 'DD/MM/YYYY' format.

Then how to select Particular year.

Once check with attachment.

[Anonymous]

Thank you Manish and Mayil

[#8]

Hi Amar,

You will know Date Function right.

Just Write like this:

Year(Your Req Field) = '2014'

or

where Date<='your req date';

Ramya.

[Anonymous]

Thank you Ramya