topic filter question in QlikView

filter question

Fri, 27 Jun 2014 10:13:54 GMT

hi!

i'm working on this table and i want to create a filter where i can insert a start day, for example 9/5/14, and an end day ,for example 11/5/14, and it shows me automatically in the table all data between 9/5/14 and 11/5/14. So how can i obtain this result??

thanks

Gabry.

Re: filter question

Gysbert_Wassenaar — Fri, 27 Jun 2014 10:15:44 GMT

See this tutorial: Selecting Arbitrary Date Ranges

Re: filter question

SunilChauhan — Fri, 27 Jun 2014 10:18:32 GMT

Load

Day,

Seq,

Act,

File,

[File Refrence],

[Register Number]

from path where Day>=''9/5/2014' and Day<='11/5/2014';

you may use and add remainig filed name you have in above code .

hope this helps

Re: filter question

amit_saini — Fri, 27 Jun 2014 10:23:48 GMT

Hi Gabriele,

You can use script below to select date ranges: (Here in this case I'm considering from 2010 till date, you can change accordingly)

LET vMinDate = num(makedate(2010));

LET vMaxDate = num(today());

Datefield:

LOAD

$(vMinDate) + IterNo() -1 as Datefield

AUTOGENERATE (1)

WHILE $(vMinDate) + IterNo() -1 <= $(vMaxDate);

Calendar:

LOAD

Datefield as %Date,

date(Datefield) as Date,

year(Datefield) as Year,

month(Datefield) as Month,

day(Datefield) as Day,

week(Datefield) as Week,

weekday(Datefield) as Weekday

RESIDENT Datefield;

drop table Datefield;

Thanks,

Re: filter question

its_anandrjs — Fri, 27 Jun 2014 10:57:51 GMT

You can use calendar object for that for selecting the date ranges or simple if just write like below scripts in any date field list box to filter data quickly.

'>=9/5/2014 <=11/5/2014'