Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Supplier | Packing | Cur | Price | Datum |
Supplier1 | 24/50/40 | USD | 108,00 | 29-1-2019 |
Supplier2 | 24/50/40 | EUR | 84,00 | 4-9-2017 |
Supplier5 | 12/75/40 | EUR | 99,00 | 3-2-2016 |
Supplier2 | 24/50/40 | EUR | 29,40 | 15-8-2018 |
Supplier3 | 24/50/40 | EUR | 27,00 | 16-10-2018 |
Supplier1 | 12/100/40 | USD | 103,00 | 29-8-2005 |
Supplier4 | 24/50/40 | EUR | 69,36 | 2-10-2014 |
Supplier2 | 24/50/40 | EUR | 78,00 | 2-3-2015 |
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:
Supplier | Packing | Cur | Price | Datum |
Supplier1 | 24/50/40 | USD | 108,00 | 29-1-2019 |
Supplier2 | 24/50/40 | EUR | 84,00 | 4-9-2017 |
Supplier2 | 24/50/40 | EUR | 29,40 | 15-8-2018 |
Supplier3 | 24/50/40 | EUR | 27,00 | 16-10-2018 |
The dates in the Excel sheet have the following format DD-MM-YYYY.
How can I do this?
Hey Tom,
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.
-Shubham
Hi,
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?
Thanks
//Andrei
Hi Tom,
You can check the attached test file.
Here, I have taken a Date variable and use it under chart in Expression.
Hi Shubham,
I managed to create input box and variable, and I created a Button object.
All working.
But i have trouble understanding the part of how to "pass date value in field and variable in search string".
Can you pls. explain more detailed what I need to do.
Thanks,
Tom