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]

Make sure that BG_DETECTION_DATE contains only date values, not timestamp values, i.e. a date + a time fraction. Perhaps you need to split your BG_DETECTION_DATE field into a date and a time field:

LOAD

    Floor(BG_DETECTION_DATE) as BG_DETECTION_DATE,

    Frac(BG_DETECTION_DATE) as BG_DETECTION_TIME,

    ...other fields

FROM ....

[Anonymous]

No, I've data in BG_DETECTION_DATE column like "2012-04-25" ,"2013-07-29"

[#4]

Hi Prakash,

I think put like this Date as BG_DETECTION_DATE,  instead of   Date as BG_DETECTION_DATE,Date,

[Gysbert_Wassenaar]

Make sure those values are date values and not text values. You can use the date# function to turn text values into dates: date#(BG_DETECTION_DATE, 'YYYY-MM-DD') as BG_DETECTION_DATE.

And check that $(vEndDate) has a value.

[Anonymous]

I tried but not yet working:(

[Anonymous]

vStartDate value is : 42040 and vEndDate value is : 41918.999999988

[#8]

Hi,

could you send your sample qvw.

[mightyqlikers]

Hi

try  below snippet

date(floor(datefield),'DD-MM-YYYY')

Regards

Samwise

[Anonymous]

Hi,

I've attached my sample .qvw file with few graph, In that graphs we have date columns and  normal filter is working. But am  trying to use Year, Month and Quarter, Filters not applied with the graphs.