Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

joeybird
Contributor II

End of Week & End of month

Hiya

using ....

let vstart='20050101';

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)

Please help

Kind Regards

joeybird

1 Solution

Accepted Solutions
jpenuliar
Valued Contributor III

Re: End of Week & End of month

You can also look into MonthEnd() function

3 Replies
jpenuliar
Valued Contributor III

Re: End of Week & End of month

Do you want to flag if your [OrderCompleteTargetDate] falls on a Sunday ?

you can probably do if([OrderCompleteTargetDate] = WeekEnd(Today()),1,0)

jpenuliar
Valued Contributor III

Re: End of Week & End of month

You can also look into MonthEnd() function

joeybird
Contributor II

Re: End of Week & End of month

Hiya

worked a treat

thank you

kind regards

joeybird