topic Re: Dates Criteria in QlikView

Dates Criteria

pavanthota — Fri, 29 Jun 2012 14:00:07 GMT

I have one field called Date in source file having data from 01-APR-2012 to 31-JUN-2012 with the same formats in these data i want to seperate from 01-MAY-2012 to 31-MAY-2012 by using script and in this data i want to convert "MAY" to 06 can anyone help on this

Re: Dates Criteria

Jason_Michaelides — Fri, 29 Jun 2012 14:44:50 GMT

What exactly do you want to end up with?? It sounds like you want a list of dates with mixed formatting and where the month is May (the 5th month) to show it as 06. Is this right!?

Re: Dates Criteria

pavanthota — Fri, 29 Jun 2012 15:03:31 GMT

Hi Jason,

Thanks for your reply

i have data in the "Date" field from 01-APR-2012 to 31-JUN-2012 in the Source file

My Requirements:

1) I want to seperate the data from the above data '01-MAY-2012' to '31-MAY-2012' by using script.

2) After Getting the May data i need to Populate the data in different field 05 Instead of MAY from the date field.

Thanks,

Pavan

Re: Dates Criteria

Jason_Michaelides — Sun, 01 Jul 2012 12:45:21 GMT

I'm sorry Pavan but I still don't understand. If you post an example of how your data looks now and how you want it to look at the end then I can help further.

Jason

Re: Dates Criteria

sridhar240784 — Sun, 01 Jul 2012 13:48:47 GMT

Hi Pavan,

I assume, you would like to load the data only for the month of May and want extract the date from the date field. if so below is the code.

Load *,

Date(Date#(DateField,' DD-MMM-YYYY')) DateNor,

Num(Month(Date#(DateField,' DD-MMM-YYYY')),'00') as MonthNum,

Day(Date#(DateField,' DD-MMM-YYYY')) as Day,

Year(Date#(DateField,' DD-MMM-YYYY')) as Year

From Table where MonthName(Date#(DateField,' DD-MMM-YYYY')) = 'May 2012';

Hope this helps you.

-Sridhar

Re: Dates Criteria

pavanthota — Tue, 03 Jul 2012 07:28:31 GMT

Hi ,

Thanks for your Sridhar , I tried your code its not working for me i am giving example can you check and give me an example

i have one txt file with the fields called A,B,C and D

A B C D

x y z 01-APR-2012

c v b 01-MAY-2012

w e r 24-MAY-2012

t y c 31-MAY-2012

r y u 15-JUN-2012

I want to load this text file in to Qlikview and i need to present only may data in Qlikview by using date filters in the script.

I have tried like below but its not working.

Load

From sample.txt

Where D >= '01-MAY-2012 and D<= '31-MAY-2012';

Can you suggest me how to write scripting code

Re: Dates Criteria

sridhar240784 — Tue, 03 Jul 2012 12:33:11 GMT

Hi,

Attached is an example for your query.

Hope this helps.

-Sridhar

Re: Dates Criteria

pavanthota — Wed, 04 Jul 2012 08:04:47 GMT

Hi Sridhar,

Thanks alot Sridhar it works for me i am new to qlikview can you suggest me how to learn qlikview ASAP.

Thanks,

Pavan