topic Re: if codition in QlikView

if codition

marksmunich — Thu, 18 Sep 2014 07:56:00 GMT

Hello Community,

Can some one say how to solve this condition. It is not working with the two time Limits, how to set upper and lower time Limits . It is working fine with one time codition but not with two conditions.

If(Wildmatch(weekday(today()),'Mo','Di','Mi','Do','Fr' ) AND

time(now()) > time(Time#('09:00:00','hh:mm:ss')) AND

time(now()) < time(Time#('09:30:00','hh:mm:ss')),1,0)

Re: if codition

MK_QSL — Thu, 18 Sep 2014 08:18:38 GMT

=IF(WildMatch(Lower(WeekDay(Today())),'*mo*','*di*','*mi*','*do*','*fr*') and

Time(Frac(Now())) > Time(Time#('09:00:00','hh:mm:ss')) and

Time(Frac(Now())) < Time(Time#('09:30:00','hh:mm:ss')),1,0)

Re: if codition

jagan — Thu, 18 Sep 2014 08:22:30 GMT

Hi,

Try like this

If(Wildmatch(weekday(today()),'*Mo*','*Di*','*Mi*','*Do*','*Fr*' ) AND

time(now()) > time(Time#('09:00:00','hh:mm:ss')) AND

time(now()) < time(Time#('09:30:00','hh:mm:ss')),1,0)

Regards,

jagan.

Re: if codition

marksmunich — Thu, 18 Sep 2014 08:34:01 GMT

Thanks Manish, the Problem was caused by Frac() function.

Iam using this now:

If(Wildmatch(weekday(today()),'Mo','Di','Mi','Do','Fr' ) and

Time(Frac(Now())) > Time(Time#('09:00:00','hh:mm:ss')) and

Time(Frac(Now())) < Time(Time#('10:30:00','hh:mm:ss')),1,0)

Re: if codition

marksmunich — Thu, 18 Sep 2014 09:03:16 GMT

Problem is solved jagan.

If(Wildmatch(weekday(today()),'Mo','Di','Mi','Do','Fr' ) and
Time(Frac(Now())) > Time(Time#('09:00:00','hh:mm:ss')) and
Time(Frac(Now())) < Time(Time#('10:30:00','hh:mm:ss')),1,0)

Thanks anyways for the quick Response.