Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to apply filter on year, I am able to see many years of data like 2010,2011,2012 etc.. I would like to see present data only i.e. from JAN 2012- till date.
How can I acheive this? Here I am making 'changes into Server Monitoring Report'
BR,
anta
use
load *
from *** . qvd
where year(Datefield)='2012'
load *
from *** . qvd
where year(Datefield)>=year(today())
DO I need to use both these laod statement.?
Ok, for example if we assume below code is it correct?
QVSTime:
Load DISTINCT
DateMinuteKey,
Date(floor(Timestamp)) as date,
weekday(Timestamp) as Weekday,
Year(Timestamp) as Year,
Month(Timestamp) as Month,
num(Month(Timestamp)) as MonthNbr,
Week(Timestamp) as Week,
Day(Timestamp) as Day,
Hour(Time(Timestamp)) as Hour,
Minute(Time(Timestamp)) as Minute,
Date(MonthStart(Timestamp),'MMM-YYYY') as YearMonth,
WeekStart(Timestamp) as YearWeek
resident $(myFile) where Year(Timestamp)='2012';
I want to fetch data from 2012 only. I don't need previous years of data now.
yes this is correct
reload this n check the output i hope u will get ur desired result...
Already did but still I am able to see 2011 data also
can u share ur sample app
I can not share that application but may be a snapshot.
But this should not happen i have attched a sample please check that out
Hi try using thisYear(Timestamp)<>Year that you want to show.
Regards
Kamal