Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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.
Not applicable

If / and statements

Hello, new to Qlikview and nearly finished my first project!

I am trying to work out how many helpdesk tickets we have had open since yesterday. In the database the open ticket is marked as "Scheduled" and I want to looked at tickets with a date other than todays...

My script at the moment looks like this..

     if(Status='Scheduled',[Start Date]<>Today(),) As [Open Before Today]

The status works but not the start date.

1 Solution

Accepted Solutions
MVP
MVP

Re: If / and statements

if(Status='Scheduled' and [Start Date]<>Today(), 1, 0) As [Open Before Today]

2 Replies
MVP
MVP

Re: If / and statements

if(Status='Scheduled' and [Start Date]<>Today(), 1, 0) As [Open Before Today]

Not applicable

Re: If / and statements

Thanks! This worked great

Community Browser