topic Re: YTD exclude current month. in QlikView

YTD exclude current month.

Anonymous — Sun, 03 Aug 2014 18:32:35 GMT

Hi, How to exclude current month which is running now ,not to show in ytd even they select current month ?

For now, I have taken max(year) and <=max(month) to show YTD in expression.

Re: YTD exclude current month.

aveeeeeee7en — Sun, 03 Aug 2014 19:21:55 GMT

max(yearfieldname) and Monthfieldname<>Month(today())

Re: YTD exclude current month.

Anonymous — Mon, 04 Aug 2014 17:00:02 GMT

this will not include for months of previous year also,

for example if I select 2013, August; it will only show till July 2013... I think I have to take Yearmonth as reference...

Re: YTD exclude current month.

joshabbott — Mon, 04 Aug 2014 17:04:27 GMT

YTD shouldn't include month's from a previous year.

Re: YTD exclude current month.

Anonymous — Mon, 04 Aug 2014 17:15:11 GMT

ytd will not include months from previous year but when i select prevous year and a month, it will show ytd for that year and till that month selected.

Re: YTD exclude current month.

joshabbott — Mon, 04 Aug 2014 17:18:03 GMT

Ahh, I gotcha.

[Your Month Field] < Month(Today())

Re: YTD exclude current month.

Anonymous — Mon, 04 Aug 2014 20:06:53 GMT

This is not actually I am looking for.Above expression for 2014 It will give correct display but when I select 2013 or 2012 will also exclude month(today()). I want for previous years to have YTD till august end by selection of august and for current year should have till July.

I know it should have reference of month-year concatenated field... I am not able to put it in expression.

Re: YTD exclude current month.

joshabbott — Mon, 04 Aug 2014 20:15:25 GMT

Will they only be selecting one year?

If so:

if(year(today()=only([selected year field]), [Your Month Field]< Month(Today()), [Your Month Field] <= Month(Today()))

Re: YTD exclude current month.

Anonymous — Mon, 04 Aug 2014 20:31:20 GMT

but now, I am using set analysis, how can I make it ?

How Can I make it to If condition?