How to filter date to restrict data

[#1]

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

[#2]

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.

[whiteline]

Post your load script.

Or at least the table structure screen.

[#4]

[whiteline]

Try:

where Year(Timestamp)=2012;

[flipside]

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

[whiteline]

It's approximately =Year(9000)

[#8]

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.

[#9]

sorry whiteline but I am not getting ypur point here...

whiteline wrote:

It's approximately =Year(9000)

[whiteline]

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.