Discussion board where members can learn more about Qlik Sense App Development and Usage.
below expression is not working at script level.
LET vWeek_End_Not <> date(max(week_ending)-7,'DD/MM/YYYY')
What about you change things like this?
LET vWeek_End_Not = date(max(week_ending)-7,'DD/MM/YYYY');
Then you put it into a where clause, for instance:
From your_db where week_ending <> '$(vWeek_End_Not)';
Try this out and tell us what happened.
Max function not work in "Let" statement.
You need to try like below
Load max(week_ending) as MaxWeek resident yoursourcetable;
Let vWeek_End_Not = Date(Peek('MaxWeek')-7,'DD/MM/YYYY');
* from your_Sourcetable where week_ending <> '$(vWeek_End_Not)';
Hope it helps