topic Re: Class function on date in QlikView

Class function on date

punitpopli — Mon, 29 Dec 2014 07:36:48 GMT

Hi All,

I am having a requirement to group date in the group of 4 (for e.g.), I am achieving this using class function as : Class(Date,4,'x').

But the calculated dimension giving the result in numbers as 41920<=x<41924 (highlighted with purple in screen shot below). Can we convert the result in numbers to Date?

Attached is the sample spreadsheet for your reference.

Thanks in advance

Punit

Re: Class function on date

Anonymous — Mon, 29 Dec 2014 07:44:54 GMT

Just replace your expression with =date(class(WeekEndingDate,4,'x'))

Re: Class function on date

Anonymous — Mon, 29 Dec 2014 07:46:58 GMT

find working file

Re: Class function on date

saumyashah90 — Mon, 29 Dec 2014 07:48:06 GMT

Did you want this?

Re: Class function on date

ecolomer — Mon, 29 Dec 2014 07:50:34 GMT

You can use also INTERVALMATCH function

Re: Class function on date

preminqlik — Mon, 29 Dec 2014 07:59:50 GMT

hi try this

=date(subfield(class(WeekEndingDate,4,'x'),'<= x <',1),'DD/MM/YYYY') &'<= x <' &date(subfield(class(WeekEndingDate,4,'x'),'<= x <',2),'DD/MM/YYYY')

Re: Class function on date

punitpopli — Mon, 29 Dec 2014 11:04:49 GMT

Hi PREMinQLIK,

Is their a way to replace "x" with the actual date in the middle of the range like :

23/12/2014 <= 26/12/2014 < 27/12/2014 ? as 26/12/2014 is the actual date.

Please let me know if you have implemented.

Thanks in advance

Punit

Re: Class function on date

preminqlik — Mon, 29 Dec 2014 21:07:50 GMT

hi there, try this,, you need to playaround with subfield or replace or findoneof()

=date(subfield(class(WeekEndingDate,4,WeekEndingDate),' <= ',1),'DD/MM/YYYY') &' <= ' &

date(subfield(subfield(class(WeekEndingDate,4,WeekEndingDate),' <= ',2),' < ',1),'DD/MM/YYYY')

' < '&date(subfield(class(WeekEndingDate,4,WeekEndingDate),' < ',2),'DD/MM/YYYY')

@premhas

Re: Class function on date

ecolomer — Mon, 29 Dec 2014 21:12:37 GMT

You can use some Variables to store formulas

Re: Class function on date

beskqlik — Mon, 13 May 2019 04:21:45 GMT

By using the expression, can we get only last 90 dates data and use this expression on that data.

Re: Class function on date

beskqlik — Mon, 13 May 2019 04:22:50 GMT

by using the expression, can we get only last 90 days dates and split on based on that dates