Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Use of If(Match) with multiple dates >= <=

Dear all,

How can I use the dimension If(Match) with dates?

I know how to show a specific date, e.g. 02/02/2016. I managed by writing =If(Match(Orderdate, '02/02/2016'), Orderdate)

I now want all values between 02/02/2016 and 02/03/2016 so I should be able to use >= and <= in my formula or use something else than If(Match).

Can anybody help me?

Side note: I am not allowed to change anything in the script, so it should be solved within my used dimensions.

Thanks in advance!

Tags (1)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Use of If(Match) with multiple dates >= <=

Perhaps like this: If(Orderdate >= '02/02/2016' and Orderdate <= '02/03/2016', Orderdate)


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
MVP & Luminary
MVP & Luminary

Re: Use of If(Match) with multiple dates >= <=

Perhaps like this: If(Orderdate >= '02/02/2016' and Orderdate <= '02/03/2016', Orderdate)


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Not applicable

Re: Use of If(Match) with multiple dates >= <=

Of course! I've used this before! I was confused by the use of if(Match) since I've been using that quite a lot lately.

Thans for your quick response!