topic Re: How to filter date to restrict data in QlikView

How to filter date to restrict data

Thu, 13 Sep 2012 06:05:14 GMT

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

Re: How to filter date to restrict data

rajni_batra — Thu, 13 Sep 2012 06:10:01 GMT

use

load *

from *** . qvd

where year(Datefield)='2012'

load *

from *** . qvd

where year(Datefield)>=year(today())

Re: How to filter date to restrict data

Thu, 13 Sep 2012 06:12:37 GMT

DO I need to use both these laod statement.?

Re: How to filter date to restrict data

Thu, 13 Sep 2012 06:16:33 GMT

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.

Re: How to filter date to restrict data

rajni_batra — Thu, 13 Sep 2012 06:20:30 GMT

yes this is correct

reload this n check the output i hope u will get ur desired result...

Re: How to filter date to restrict data

Thu, 13 Sep 2012 06:21:31 GMT

Already did but still I am able to see 2011 data also

Re: How to filter date to restrict data

rajni_batra — Thu, 13 Sep 2012 06:22:26 GMT

can u share ur sample app

Re: How to filter date to restrict data

Thu, 13 Sep 2012 06:33:29 GMT

I can not share that application but may be a snapshot.

Re: How to filter date to restrict data

rajni_batra — Thu, 13 Sep 2012 06:38:12 GMT

But this should not happen i have attched a sample please check that out

Re: How to filter date to restrict data

kamalqlik — Thu, 13 Sep 2012 08:46:46 GMT

Hi try using thisYear(Timestamp)<>Year that you want to show.

Regards

Kamal

Re: How to filter date to restrict data

Fri, 14 Sep 2012 09:06:40 GMT

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.

Re: How to filter date to restrict data

whiteline — Fri, 14 Sep 2012 09:19:43 GMT

Post your load script.

Or at least the table structure screen.

Re: How to filter date to restrict data

Fri, 14 Sep 2012 09:35:17 GMT

Re: How to filter date to restrict data

whiteline — Fri, 14 Sep 2012 10:38:29 GMT

Try:

where Year(Timestamp)=2012;

Re: How to filter date to restrict data

flipside — Fri, 14 Sep 2012 11:14:52 GMT

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

Re: How to filter date to restrict data

whiteline — Fri, 14 Sep 2012 11:19:40 GMT

It's approximately =Year(9000)

Re: How to filter date to restrict data

Mon, 17 Sep 2012 05:08:54 GMT

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.

Re: How to filter date to restrict data

Mon, 17 Sep 2012 05:11:24 GMT

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

whiteline wrote:
It's approximately =Year(9000)

Re: How to filter date to restrict data

whiteline — Mon, 17 Sep 2012 05:46:30 GMT

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.