Filter

[TomHolland]

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?

[Shubham_Deshmukh]

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

[crusader_]

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

[prabir_c]

Hi Tom,

You can check the attached test file.

Here, I have taken a Date variable and use it under chart in Expression.

[TomHolland]

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