topic Re: Create a Filter to select data from specific date, up to Today in QlikView

Create a Filter to select data from specific date, up to Today

Anonymous — Thu, 16 Nov 2017 19:38:20 GMT

Hi comunity!

Any ideas on how to create a filter to select information from 6 and 12 months ago up to today?

I have a QV Document which shows all data referring to Purchase Orders and I need to create a filter that, taking Today() as starting date, allows me to filter the POs created for the last 6 or 12 months leaving all others aout.

Any Ideas?

Thanks all!

Best Regards,

Re: Create a Filter to select data from specific date, up to Today

Anonymous — Thu, 16 Nov 2017 19:59:07 GMT

Not sure what you're asking for.

Do you want a bookmark that does it? You could write a search expression on your date field for that.

Or do you want it for set analysis in a chart?

Otherwise, if you want a list box with those options, I would recommend creating a calendar with the last 6 or 12 months indicated in columns in calendar.

Re: Create a Filter to select data from specific date, up to Today

Anonymous — Fri, 17 Nov 2017 11:13:55 GMT

Hi Wallo, thanks for your answer.

Let me be more specific here.

This QV document loads all the POs stored in an SQL table. In the front end, users see a simple table object with all data (creation date, items, supplier, amount, an so on).

What I need, is some kind of filter that, when selected, filters the data to show only the POs created for the last 6 or 12 months.

I imagine a listbox with two options: "Last 6 months" and "Last 12 months", for example.

Thank you for your time.

Re: Create a Filter to select data from specific date, up to Today

Anonymous — Fri, 17 Nov 2017 12:27:30 GMT

Hi all.

Just to let you know this is solved. Finally I did it with an "IF" statement in the script.

If ([Creation Date] >= (Today()-180), 'OK') AS [Last 6 Months]

Same for 12 months. Then I created a list box for each field in the Front End.

When the users select any of them, data in the main table is updated according to selection.

I´m new to QlikView. Sorry if i was not clear enough and thank you for your time.

Regards.