topic Re: year to date in QlikView

year to date

Fri, 20 Sep 2013 04:45:39 GMT

Hi,

Doing stuff on the YTD. Please look at the rightmost chart in the attachment. Here I want to display the date from the current year and not the date from the last year, though I want to display the figures from the previous year.

If you look at the rightmost chart in the attached file the chart displays 03/07/2013 and 10/07/2013 as the dates from the current year.

The chart now displays 4 rows where I expect to see only 2 rows as follows. i.e. I need to display the dates only from the current year.

DateF Year Month Week Day Current Previous

03/07/2013 2013-2014 1 1-1 1 720 220

10/07/2013 2013-2014	2	2-2	1	410 60

Thanks,

Ram

Re: year to date

tresB — Fri, 20 Sep 2013 04:57:17 GMT

Your previous year data is for some other dates and you want to show them against other dates, how is this logical? I guess, your date field is not relevant here.

Re: year to date

Fri, 20 Sep 2013 04:58:17 GMT

Hi, The relevance is not based on the dates. It is based on the Month + Week + Day combination. A date this year points to a different date last year based on that combination.

Thanks,

Ram

Re: year to date

Fri, 20 Sep 2013 05:00:24 GMT

09/07/2012,2012-2013,2,2-2,1,29

09/07/2012,2012-2013,2,2-2,1,31

10/07/2013,2013-2014,2,2-2,1,80

10/07/2013,2013-2014,2,2-2,1,350

Here, 10-Jul-2013 this year is 430. The same day last year is 09-Jul-2012 and 60. That is by matching Month(2), Week(2-2) and Day(1).