Year,Month and Quater filters not reflected in Graphs

[Anonymous]

Hi All,

The Below code has been currently using in my .qvw file and i have data in year from 2011 to 2014.

LOAD DISTINCT
Date as BG_DETECTION_DATE,Date,
Year(Date) as Year,
Month(Date) as Month,
Date(MonthStart(Date), 'MMMYY') as MonthYear,
if(monthstart(Date) <= $(vTodaysDate), 1, 0) as _History,
'Q' & Ceil(Month(Date)/3) as Quarter,
Dual('Q' & Ceil(Month(Date)/3) & '-' & Year(Date), Year(Date) & Ceil(Month(Date)/3)) as QtrYear,
Week(Date) as Week,
Weekstart(Date) as Weekstart,
Weekend(Date) as Weekend
;
Load
Date($(vEndDate) - RecNo() +1) as Date
AutoGenerate($(NumberOfDays));

If i'm selecting Year ,Month, Quarter, its not filtered in my graphs even i added year column in Date as BG_DETECTION_DATE in Load.

What is wrong in my file?

How can i filter with the Year , Month and Quarter in my graphs?

Thanks in advance,

[Gysbert_Wassenaar · Accepted solution]

vEndDate value is : 41918.999999988

That's why your dates have time fractions:

That's why they don't match with your  table.

[Anonymous]

Ok, then how can i avoid this problem? what i have to change in my file?

[Gysbert_Wassenaar]

Change your vEndDate value. Set it to 41918 or 41919.

[Anonymous]

thank you Gysbert Wassenaar and Awesome , my file working fine with filter.