Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
marksmunich
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
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
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
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.

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

marksmunich
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.

Community Browser