Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
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
swuehl
MVP
MVP

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

View solution in original post

2 Replies
swuehl
MVP
MVP

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

Not applicable
Author

Thanks! This worked great