How to filter data in qlikview by yeartodate function

Thu, 10 Oct 2013 00:46:50 GMT

I am unable to work with filtering data by using yeartodate function, Can any have any suggestion on the same?

Re: How to filter data in qlikview by yeartodate function

villegasi03 — Thu, 10 Oct 2013 01:01:07 GMT

I normally add a flag when I am loading my calendar or a table with dates you will want to look at year to date.

LET vDateToday = TODAY();

LOAD

YOURDATE AS DATE,

INYEARTODATE(YOURDATE, $(vDateToday), 0) * -1 AS YTD

FROM YOURCALENDARTABLE;

Now, when you want to use this in an expression you can use an IF statement or set analysis. For example.

IF(YTD = '1', SUM(SOMETHING))

SUM({<YTD = {'1'}>}SOMETHING)