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
Hi
Still not working. I want to removed the other years from filer list. Please check the above screen shot.
I am able to see 2010,2011 n 2012's data.
Post your load script.
Or at least the table structure screen.
Try:
where Year(Timestamp)=2012;
You've got a year showing of 1924, which is a bit early for Qlikview log data . I'd be tempted to find out where that came from first.
flipside
It's approximately =Year(9000)
Yes, we are just able to see that year but no data found for that particular year..
I don't why filter is not working for 2012.
sorry whiteline but I am not getting ypur point here...
whiteline wrote:
It's approximately =Year(9000)
In your data structure Year appearse only in one table with one load.
If there is 1924 year, this means that somehow Timestamp was ~9000.
I think you should carefuly look throug your input data.