Discussion board where members can get started with QlikView.
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'
from *** . qvd
DO I need to use both these laod statement.?
Ok, for example if we assume below code is it correct?
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.