topic Re: Filter in QlikView

Filter

TomHolland — Sat, 16 Nov 2024 04:08:58 GMT

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?

Re: Filter

Shubham_Deshmukh — Mon, 18 Mar 2019 05:03:41 GMT

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

Re: Filter

crusader_ — Mon, 18 Mar 2019 05:08:56 GMT

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

Re: Filter

prabir_c — Mon, 18 Mar 2019 06:11:45 GMT

Hi Tom,

You can check the attached test file.

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

Re: Filter

TomHolland — Fri, 24 Jan 2020 21:53:07 GMT

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