Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

TomHolland
New Contributor II

Filter

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?

Labels (1)
3 Replies
Shubham_Deshmukh
Valued Contributor

Re: Filter

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

Partner
Partner

Re: Filter

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

Highlighted
Partner
Partner

Re: Filter

Hi Tom,

You can check the attached test file.

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