topic Re: button formula not quite working in QlikView

button formula not quite working

samuel_brierley — Thu, 24 Jul 2014 13:28:56 GMT

Hi all,

first of all thanks for any help on this, iu have the following formula that is supposed to say if the date is a fri skip to next monday if not move to next day. i think my formula is logical however the skip to monday part doesnt work.

if(Date(Date,'DDD')= 'Fri', Date(Date+3),Date(Date+1))

thanks for any help

Re: button formula not quite working

Anonymous — Thu, 24 Jul 2014 13:31:48 GMT

try using Day instead of of the first Date :

if(Day(Date,'DDD')= 'Fri', Date(Date+3),Date(Date+1))

Re: button formula not quite working

michael_maeuser — Thu, 24 Jul 2014 13:39:48 GMT

hi,

if(WeekDay(Today())='Fri', date(Today()+3), date(Today()+1))

Re: button formula not quite working

samuel_brierley — Thu, 24 Jul 2014 13:45:38 GMT

Hi this is getting the same result as i was getting,

i think the reason for this is because i dont actually have any data for saturday or sunday,mayb knowing this would help.

Re: button formula not quite working

preminqlik — Thu, 24 Jul 2014 14:42:50 GMT

use max(Date) like below

if(Date(max(Date),'DDD')= 'Fri', Date(max(Date)+3),Date(max(Date)+1))

Re: button formula not quite working

maxgro — Thu, 24 Jul 2014 14:55:14 GMT

=if(WeekDay(Date)=4, ..., ...)

Re: button formula not quite working

Fri, 25 Jul 2014 01:02:07 GMT

Hi Samuel

I agree with Massimo in that

If(Weekday(Date)=4,Date(Date+3,'DD/MM/YYYY'),Date(Date+1,'DD/MM/YYYY'))

will return the date of the following Monday if the Date is a Friday or the date of the next day if Date is not a Friday.

Sample results are:

Kind regards

Steve