Discussion Board for collaboration related to Creating Analytics for QlikView.
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!
Go to Solution.
Hi Neena B:
=IF(Date(Today())-Max([Order Date])>367 AND Date(Today())-Max([Order Date])<763, [Bill To Name])
Today function don't need Max.
View solution in original post
So simple! Thanks!!