topic Re: Data filter by Year, Month and Day in QlikView

Data filter by Year, Month and Day

Tue, 01 Sep 2015 15:14:52 GMT

Hello! I am new in QlikView.

I need to produce the filters by year, month and day, as shown below:

Can someone help me ?

Thanks.

Re: Data filter by Year, Month and Day

nigel987 — Tue, 01 Sep 2015 16:55:02 GMT

Hi Filipe,

Is your date field already available as year, month, day in the data model?

If not, you need to do the following in the script (just replace Your_Date_Field and Table_of_Your_Date_Field with your own field and table names).

Date:

LOAD

Your_Date_Field,

Year(Your_Date_Field) AS Year,

Month(Your_Date_Field) AS Month,

Day(Your_Date_Field) AS Day,

Resident Table_of_Your_Date_Field;

Reload the script and then create three listbox objects. One with the field Year, one with Month and one with Day. Is that clear?

I've attached a sample file.

Re: Data filter by Year, Month and Day

petter — Tue, 01 Sep 2015 17:15:24 GMT

I just used ValueList() and ValueLoop() to make expressions for the three listboxes. You can replace each with Year, Month and Day from your data model (table).

Re: Data filter by Year, Month and Day

Tue, 01 Sep 2015 17:17:45 GMT

Hi Nihal,

Yes, the dates are already in this model.

I cannot put in the layout of the image that I posted. I need to put a checkbox for each year, month and day, and the user can select one or more values.

Thank you for your help!

Re: Data filter by Year, Month and Day

petter — Tue, 01 Sep 2015 17:18:15 GMT

To get it horizontal and with the checkboxes you will have to go to the Presentation tab for each of the list boxes and remove the checkmark from Single Column and from the drop-down "Selection Style Override" select Windows Checkboxes. Lastly you must drag the lower-right corner of the list box so it becomes much wider than it is high and it will reformat to a horizontal format instead of vertical.

Re: Data filter by Year, Month and Day

Tue, 01 Sep 2015 17:18:51 GMT

Hi Nihal,

Yes, the dates are already in this model.

I cannot put in the layout of the image that I posted. I need to put a checkbox for each year, month and day, and the user can select one or more values.

Thank you for your help!

Re: Data filter by Year, Month and Day

Tue, 01 Sep 2015 17:32:29 GMT

Petter,

It´s worked! Thank you so much.