Expression for YearToDate, CurrentQuarter,CurrentPeriods on Selection

Wed, 08 Jan 2014 18:55:28 GMT

Hi,

Can anyone help me out writing an expression for Expression for YearToDate, CurrentQuarter,CurrentPeriods on Search criteria ?

Re: Expression for YearToDate, CurrentQuarter,CurrentPeriods on Selection

Thu, 09 Jan 2014 09:40:36 GMT

Hi,

Why not use master calendar as below?

TEMP:

LOAD

num(min(OrderDate)) AS MinDate,

num(max(OrderDate)) AS MaxDate

RESIDENT

OrderDetails;

LET vMinDate = peek('MinDate', 0, 'TEMP');

LET vMaxDate = peek('MaxDate', 0, 'TEMP');

DROP TABLE TEMP;

DateIsland:

LOAD

date($(vMinDate) + rowno() - 1) AS D,

year($(vMinDate) + rowno() - 1) AS Y,

month($(vMinDate) + rowno() - 1) AS M,

date(monthstart($(vMinDate) + rowno() - 1), 'MMM-YYYY') AS MY

AUTOGENERATE

vMaxDate - vMinDate + 1;

TEMP:

LOAD

num(min(OrderDate)) AS MinDate,

num(max(OrderDate)) AS MaxDate

RESIDENT

OrderDetails;

LET vMinDate = peek('MinDate', 0, 'TEMP');

LET vMaxDate = peek('MaxDate', 0, 'TEMP');

DROP TABLE TEMP;

DateIsland:

LOAD

date($(vMinDate) + rowno() - 1) AS D,

year($(vMinDate) + rowno() - 1) AS Y,

month($(vMinDate) + rowno() - 1) AS M,

date(monthstart($(vMinDate) + rowno() - 1), 'MMM-YYYY') AS MY

AUTOGENERATE

vMaxDate - vMinDate + 1;

And then you could create some flags:

inyeartodate(D, $(vToday), 0) * -1 AS CYTD,

inmonthtodate(D, $(vToday), 0) * -1 AS CMTD,

And then you could create some flags:

inyeartodate(D, $(vToday), 0) * -1 AS CYTD,

inmonthtodate(D, $(vToday), 0) * -1 AS CMTD,

topic Re: Expression for YearToDate, CurrentQuarter,CurrentPeriods on Selection in QlikView

Expression for YearToDate, CurrentQuarter,CurrentPeriods on Selection

Re: Expression for YearToDate, CurrentQuarter,CurrentPeriods on Selection