Discussion board where members can learn more about Qlik Sense App Development and Usage.
let vend=date(Today(), 'YYYYMMDD');
i wish to call a stat for End of week and End of Month
this below gives me 7 days
if(([OrderCompleteTargetDate]-'$(vend)') <= (7*24), 1,0) as [7 Day Warning],
how would I amend above to give me [end of week warning] ('Sunday') and [end of 'current' month warning] (current month from today will be end of May 2015)
Go to Solution.
You can also look into MonthEnd() function
Do you want to flag if your [OrderCompleteTargetDate] falls on a Sunday ?
you can probably do if([OrderCompleteTargetDate] = WeekEnd(Today()),1,0)
worked a treat