topic Re: Filter Data to Display in a Chart Table in QlikView

Filter Data to Display in a Chart Table

jmonroe918 — Wed, 15 Feb 2017 16:54:35 GMT

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

Re: Filter Data to Display in a Chart Table

sunny_talwar — Wed, 15 Feb 2017 17:04:05 GMT

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)

Re: Filter Data to Display in a Chart Table

jmonroe918 — Wed, 15 Feb 2017 19:34:59 GMT

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

Re: Filter Data to Display in a Chart Table

sunny_talwar — Wed, 15 Feb 2017 19:38:05 GMT

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.

Re: Filter Data to Display in a Chart Table

jmonroe918 — Thu, 16 Feb 2017 17:47:09 GMT

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

I'll go with your solution.Thanks!

Jeff