Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

filter question

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

1.bmpGabry.

Tags (1)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: filter question

See this tutorial: Selecting Arbitrary Date Ranges


talk is cheap, supply exceeds demand
4 Replies
MVP & Luminary
MVP & Luminary

Re: filter question

See this tutorial: Selecting Arbitrary Date Ranges


talk is cheap, supply exceeds demand
SunilChauhan
Esteemed Contributor

Re: filter question

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

amit_saini
Honored Contributor III

Re: filter question

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,

AS

Re: filter question

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'