topic Re: How to filter months using Input Box? in QlikView

How to filter months using Input Box?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys! I have to filter my chart into specific months as entered by the user on the input box. I have seen threads about input boxes byt I can't seem to tailor-fit the expressions with my own work.

What I want to do is have an input box and type in a certain month, then the chart displays the data of that month. I wouldn't also want to limit the number of months typed into the input box with only just one month but say 3 months, then all the data of those three months gets displayed on the chart.

Please help me on this and sorry if i have missed something obvious.

Thanks!

Re: How to filter months using Input Box?

suepenick — Tue, 03 Apr 2018 16:39:12 GMT

Make a list box with the Months - let them select by dragging and dropping or CTRL + Clicking to select random ones.

This is a very flexible solution as you may want to look at certain months this year over a year or year over year.

in your list box - you can select expression instead of just a dimension and do a =Year &'-'&Month

then they can randomly select months and years to compare -

or drag and see a group of months in a quarter/ what ever

input boxes are for large amounts of ranges of numbers - like from invoice number to invoice number or a very specific date range. Search for Input Boxes in the community to see how to specifically set up the variables and event triggers.

http://www.bi-tv.com/how-to-add-start-date-and-end-date-calendar-objects-in-qlikview/

I watched a video to understand input boxes

Re: How to filter months using Input Box?

MarcoWedel — Tue, 03 Apr 2018 21:06:02 GMT

why would anyone want to type a value he could easily select from a list box having only 12 values?

Re: How to filter months using Input Box?

Anonymous — Wed, 04 Apr 2018 02:46:23 GMT

Hi Sue! Thanks for your advice but the exercise I am doing now requires the use of Input Box specifically so I can't use List Box for now. The link seems to be broken as well but I sure am going to read on Input Box here at the community. Thanks!

Re: How to filter months using Input Box?

Anonymous — Wed, 04 Apr 2018 02:47:04 GMT

It's an exercise to get familiar with the Input Box object

Re: How to filter months using Input Box?

fspinelli — Wed, 04 Apr 2018 06:51:26 GMT

Hi Kat,

for the input box I use this extension Qlik Branch

In the expression of your chart you can try this:

Sum(if(vMonth = month(yourDate), do expr true, do expr false))

vMonth is the name of the input box varable, I set this variable in the main script with Let vMonth = 0

Bye

Re: How to filter months using Input Box?

Anonymous — Wed, 04 Apr 2018 09:29:49 GMT

Got it through this expression:

=Sum({<Month={$(vMonth)},[Day Name]-={'Saturday','Sunday'}>}Sales)

Re: How to filter months using Input Box?

Anonymous — Thu, 05 Apr 2018 01:55:29 GMT

Thanks for the advice Sir. I was able to resolve it after all using this expression =Sum({<Month={$(vMonth)},[Day Name]-={'Saturday','Sunday'}>}Sales).