Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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.
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.
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.
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.