Filter Data to Display in a Chart Table

[jmonroe918]

I am trying to filter the data that is displayed in a chart table (Please see the attached qvw file)

I only want to see records who's status does not equal "Closed" (and possibly "Request" as well). I've tried the following Expressions:

     =Count(Distinct{<CAPA.Status -= {'Closed'}>}CAPA.ID)

=Count(Distinct{<CAPA.Status = {'Request','Evaluate','Root Cause','CAPA Plan','Verification and Validation','Effectivness Check'}>}CAPA.ID)

They both count correctly, but the "Closed" records are still visible (and I don't want them in the table).

Additionally, I would like to only display records with "Days Late" greater than or equal to  -14 days.

Thanks in advance.

Jeff

[sunny_talwar]

You need to make your other expressions as zero by using an if statement. I used the column label (Count) to do this

If(Count > 0, Expression1)

[jmonroe918]

Hey Sunny:

Thanks for the answer, but have a question.

The formula for Days Late is saying there is an "Error in the Expression" when the If/Then statement is added. I tried several ways to figure out what is causing the  error message, but have had no luck.

Otherwise it seems to be working correctly.

Any idea?

Jeff

[sunny_talwar · Accepted solution]

I don't see the error message

This would mean that you might have an older version of QlikView installed where expression editor is unable to understand part of the syntax. but it doesn't mean that there is anything wrong with the expression. If you get what you wanted, ignore the error message by expression editor.

[jmonroe918]

Yeah I think you're right. We are still on Version 11.

I'll go with your solution.Thanks!

Jeff