Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Partner
Partner

IF then statement with > and < in expression.

I am trying to create a table that displays the customer whose last purchases was 12 months ago to 23 months ago. This is the expression I am trying to use:

=IF(Max(Date(Today()))-Max([Order Date])>367<763, [Bill To Name])

However, I am getting no data using this. How can I use the greater than and less than symbols in an expression for a straight table? Any help is appreciated!

1 Solution

Accepted Solutions
manucamon
Valued Contributor III

Re: IF then statement with > and < in expression.

Hi Neena B:

Try this:

=IF(Date(Today())-Max([Order Date])>367 AND Date(Today())-Max([Order Date])<763, [Bill To Name])

Today function don't need Max.

Kind regards

View solution in original post

2 Replies
manucamon
Valued Contributor III

Re: IF then statement with > and < in expression.

Hi Neena B:

Try this:

=IF(Date(Today())-Max([Order Date])>367 AND Date(Today())-Max([Order Date])<763, [Bill To Name])

Today function don't need Max.

Kind regards

View solution in original post

Partner
Partner

Re: IF then statement with > and < in expression.

So simple! Thanks!!