Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
pranaview
Contributor II

How to create a Week filter using an Input box and variable

Hi All,

I have to create a filter on my Week field which was created as a part of the Master Calendar.I know It can be done using an input box, so it would be really great if someone can shed some light on how it is done.

So, what I want is to provide user a functionality where he/she can just select a specific start week and end week number to filter the data for that range.

Any suggestion will be appreciated.

Kind Regards,

Pranav

1 Reply
sasikanth
Valued Contributor III

Re: How to create a Week filter using an Input box and variable

HI,
Try to create two variables ,vWeekStart, vWeekEnd and assign them to inputs boxes .

Ex .Exp: Sum({<WeekNumber={">=$(vWeekStart) and <= $(vWeekEnd)"}>} sales)

Note: Week Number Should be like (1,2,3,4,5 ..... etc)