Discussion board where members can get started with QlikView.
I have a lot of data in an Excel sheet with price info from different suppliers which selecting the product I can view as follows in Qlikview.
For some products there is a large amount of price info. For that reason I want the user to be able to filter/select by date whereby user only fills out the date. For example: 01/01/2018
Resulting in only showing:
The dates in the Excel sheet have the following format DD-MM-YYYY.
How can I do this?
Create variable of your date field and just create Input Box object and give varibale value to it.
In Input box object, user will be able to put the date and to make it work you have to create button object, in Button Properties ->Action-> pass date value in field and variable in search string.
Happy to help, but unfortunately from your example it's not quite clear how you're getting resulting table with selected date 01/01/2018.
Should it be "All prices later than <date>" or "All prices closest to <date>" or "Current price on <selected date>" or anything else?
You can check the attached test file.
Here, I have taken a Date variable and use it under chart in Expression.