# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Rules, plus terms and conditions, can be found here.
Contributor II

## if codition

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)

Tags (2)
1 Solution

Accepted Solutions
MVP

## Re: if codition

=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)

4 Replies
MVP

## Re: if codition

=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)

MVP

## Re: if codition

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.

Contributor II

## Re: if codition

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)

Contributor II

## Re: if codition

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.