topic Exclude Values in ListBox in QlikView

Exclude Values in ListBox

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I created seperated listboxes, "Case_ID", "Report_ID", "Date Submitted". One Case_ID could have multiple associated reports (Report_ID).

When I load the data fields in script, I also set condition for "Report_type" which means a certain type of reports (values associated with Report_ID, Date_Submitted) won't be listed in the ListBox.

So this will happen, I clicked on a Case_ID, but there is no clickable value shows in other listboxes.

I would like to exclude (not showing) those Case_ID values (2003-00043 in this case) associated with those reports won't show in the Listbox. But I am not sure how to achieve it.

I cannot do anything like include in the specific Case_ID in the script or expression, as there are lots of Case_ID. I cannot check manually to see which Case_ID don't have assoicated report records.

I know this logic wasn't right, but I tried to add expression for the Case_ID listbox "=if(IsNull([Submission Count]),[Case Number])" . This doesn't work obviously.

Thanks,

Becky

Re: Exclude Values in ListBox

Tue, 21 Jun 2016 18:41:33 GMT

You can use an expression on list, showing all information that's not null. See my attachment

Best,

Rodrigo Reis

Re: Exclude Values in ListBox

Tue, 21 Jun 2016 20:32:18 GMT

Thank you! This works.

I did =if(not IsNull(REPORT_ID), [Case Number])

One more question based on the result. How about if I also have null values in Case_ID?

I did this: =if(not IsNull(REPORT_ID and [Case Number]), [Case Number]) . But it doesn't work.

Please let me know if I need to be more accurate with my posting. I can create an sample and attach here.

Thanks again,

Becky

Re: Exclude Values in ListBox

jduenyas — Tue, 21 Jun 2016 20:36:49 GMT

I am not sure the script is correct.

Try =If (Not isnull(Report_ID) AND Not isnull(CseNumber),CaseNumber)

Re: Exclude Values in ListBox

Tue, 21 Jun 2016 20:39:51 GMT

Thanks so much Josh. This works!

Best,

Becky

Re: Exclude Values in ListBox

Tue, 21 Jun 2016 20:41:32 GMT

exactly what Josh said

hahaha

I'm glad to have helped,

Rodrigo Reis