Discussion board where members can get started with QlikView.
Here is my case and I hope that you can help:
my date filed name is a WeekName :
As this Form
How can I extract to data as of Max(WeekName)-1 in this case when weekName < 2017/14 I used WeekName <= Max(WeekName)-1
it didn't work.
try this may be
replace('2017/14','/','') as WeekName
then it will correctly evaluate the max values
Using Aar Kay expression you can use that inside your Max() function too, if you don't want in the script. However, script is more advisable.
<= Max(Replace(WeekName,'/','')) - 1
not sure you're using dual()s, try the following: