topic Re: Date functions in QlikView

Date functions

Mon, 28 Apr 2014 13:24:52 GMT

Hi ,all i want to make date into partitions also rejoin that partions ,

Give me some idea about date function

Re: Date functions

MK_QSL — Mon, 28 Apr 2014 13:26:57 GMT

Unclear what actually you want !!!

Re: Date functions

its_anandrjs — Mon, 28 Apr 2014 13:27:34 GMT

Suppose you have date 28042014

and you have separate them like below

=Right(28042014,4) as Year

=Mid(28042014,3,2) as Month

=Left(28042014,2) as Day

And then you can use all this to make date like

=Makedate( Right(28042014,4) , Mid(28042014,3,2) , Left(28042014,2) )

If you want like this otherwise share your sample or please explain more.

You can create date fields like

LOAD

Day(Datefield) as Day,

Month(Datefield) as Month,

Year(Datefield) as Year,

'Q' & Ceil(Month(Datefield)/3) as Quarter

From Location;

Re: Date functions

jagannalla — Mon, 28 Apr 2014 13:29:58 GMT

Hi Uday,

You can split your date using lot of techniques. Few are,

Month(DateField) as Month

Year(DateField) as Year

Day(DateField0 as Day

Date(DateField,'YYYY') as Year

Date(DateField,'MM') as Month or using 'MMM'

Date(DateField,'DD') as Day

Like this in qlikview we had lot of techniques.

But what are you expecting.

Hope it helps you!!!

Cheers!!!!!!

Jagan

Re: Date functions

Mon, 28 Apr 2014 13:30:35 GMT

If i have one year data,here i want to partition this one year data in to various parts , i want to use some funtion to partition the date as 4month or 6months,how it can be using some funtions,please reply

Re: Date functions

MK_QSL — Mon, 28 Apr 2014 13:32:27 GMT

Can you provide some sample data along with your expected result in excel file.

Looks like your requirement is not difficult to achieve but I am unable to understand it properly.

Re: Date functions

Mon, 28 Apr 2014 13:34:39 GMT

Thanks for your reply ,but am asking how to partition the date in to quarter,4month ,6months,9months ,

Re: Date functions

its_anandrjs — Mon, 28 Apr 2014 13:37:38 GMT

If you provide any sample will be better or if i am understand you can make the Flags in the load script and partition the date fields and then use in the front end

Load

If(NumMonth >=1 and NumMonth <= 5,'Month between 1 and 5 '

If(NumMonth >5 and NumMonth <= 12,'Month between 6 and 12')) as MonthFlag

from Location;

Re: Date functions

Mon, 28 Apr 2014 13:44:20 GMT

how we can spillt date using "ceil" function,please answare

Re: Date functions

MK_QSL — Mon, 28 Apr 2014 13:48:15 GMT

Considering that you have TimeStamp

Date(Floor(YourTimeStampField)) as Date

Time(Frac(YourTimeStampField)) as Time

Re: Date functions

PradeepReddy — Mon, 28 Apr 2014 13:55:58 GMT

Hi Uday

Quarter : 'Q'&Ceil(Month(Date)/3) AS Quarter

Like above expression, you can achieve the rest of the scenarios as well...

Thanks, Pradeep

Re: Date functions

MK_QSL — Mon, 28 Apr 2014 13:58:51 GMT

write below in script.

'Q' & Ceil(Month(Date)/3) as Quarter

Re: Re: Date functions

jagannalla — Mon, 28 Apr 2014 14:54:11 GMT

You can find lot of information on Master Calendar qvw file. Please find through attachment, you can open in personal addition also.