topic Re: Selecting One year Data while loading in QlikView

Selecting One year Data while loading

Anonymous — Wed, 01 Jul 2015 06:07:40 GMT

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

Re: Selecting One year Data while loading

Wed, 01 Jul 2015 06:10:23 GMT

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.

Re: Selecting One year Data while loading

sunilkumarqv — Wed, 01 Jul 2015 06:15:23 GMT

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';

Re: Selecting One year Data while loading

MK_QSL — Wed, 01 Jul 2015 06:15:24 GMT

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;

Re: Selecting One year Data while loading

MayilVahanan — Wed, 01 Jul 2015 06:16:55 GMT

Try like this

Load * from datasource

Where Year(In_date)=2014;

Re: Selecting One year Data while loading

Anonymous — Wed, 01 Jul 2015 06:17:04 GMT

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.

Re: Selecting One year Data while loading

Anonymous — Wed, 01 Jul 2015 06:20:09 GMT

Thank you Manish and Mayil

Re: Selecting One year Data while loading

Wed, 01 Jul 2015 06:36:24 GMT

Hi Amar,

You will know Date Function right.

Just Write like this:

Year(Your Req Field) = '2014'

where Date<='your req date';

Ramya.

Re: Selecting One year Data while loading

Anonymous — Wed, 01 Jul 2015 06:39:36 GMT

Thank you Ramya