topic Re: Issue - List box clears when selection is still valid in QlikView

Issue - List box clears when selection is still valid

BarbCline — Fri, 08 Sep 2017 18:13:15 GMT

Hello!

I have several list boxes to filter data. If I make a selection that clears one list box, the other list box clears ... but it should not. See my first image below... I have selected Medical, S and Communited Rated. See my second image... I have selected Financially Rated, which appropriately clears Segment S (because S is not valid for Financially Rated). But, as you can see MEDICAL is still the only appropriate Line option for Financially Rated, so why did MEDICAL clear?

I have my list boxes set up to QlikView Classic. I'm using v11.2 SR12. I have used QlikView for 5+ years and I have never had this issue. It has me baffled. Any ideas how to resolve?

Thanks!

Re: Issue - List box clears when selection is still valid

Anonymous — Fri, 08 Sep 2017 18:47:20 GMT

I would suggest you to add the same columns into a Table Box(Line, Segment, Rated Type) and make a selection in the list box (Line). Understand the data association.

Let me know if it works.

Also, Can you post the sample data to better understand what the issue is?

Thanks,

Re: Issue - List box clears when selection is still valid

BarbCline — Fri, 08 Sep 2017 18:56:54 GMT

Here's the table box ... as you can see MEDICAL is associated with all three Rated Types. I should not be losing the MEDICAL selection in the Line list box when Financially Rated is selected.

I can't share my app. I will work on creating an example qvw and post again.

Re: Issue - List box clears when selection is still valid

Anonymous — Fri, 08 Sep 2017 20:11:13 GMT

Only these segments (Z,P,L,J) would be displayed when the filters (Line='MEDICAL' & Rated Type = 'Financial Rated') is selected.

This functionality occurs because it is a combination of both the filters.

Is this what you are expecting?

Re: Issue - List box clears when selection is still valid

vishsaggi — Fri, 08 Sep 2017 20:27:59 GMT

What you mean by "I should not be losing the MEDICAL selection in the Line list box when Financially Rated is selected" ?

Medical is a possible value when Financially Rated is selected?

Re: Issue - List box clears when selection is still valid

BarbCline — Fri, 08 Sep 2017 20:33:25 GMT

I've added another list box (Region) so you can see what I'm expecting. Make the same selections as described above, and also select the WEST Region. When Financially Rated is selected, the MEDICAL Line is cleared but the WEST Region selection is retained. I expect Line to function exatly like Region.

Re: Issue - List box clears when selection is still valid

BarbCline — Fri, 08 Sep 2017 20:51:38 GMT

Yes, MEDICAL is still possible, but it's no longer "selected" ... it's no longer green. I have code based on selected Line so that makes a difference. Plus, it's annoying to my users to have to re-select MEDICAL as they move through the app.

Re: Issue - List box clears when selection is still valid

BarbCline — Mon, 11 Sep 2017 13:13:21 GMT

Good morning, QV Community!

I've been doing some testing with my example QVW and I discovered that if I change the load order of my fields, I get different results.

Original:
LOAD
rtrim(upper(LOB)) as Line,
BUS_SEGMENT_CD as Segment,
if(CR = '', 'Specialty Rated', CR) as [Rated Type],
if(isNull(BUDGET_REGION), 'WEST', BUDGET_REGION) as Region

Modified:

LOAD
if(isNull(BUDGET_REGION), 'WEST', BUDGET_REGION) as Region,
BUS_SEGMENT_CD as Segment,
if(CR = '', 'Specialty Rated', CR) as [Rated Type],
rtrim(upper(LOB)) as Line

WIth the modified Load statement, Line (now loaded last) behaves exactly as I expect, but Region (now loaded first) has "the issue". So essentially, when Segment is cleared because of a Rate Type selection, anything loaded in the script prior to Segment is also cleared. Is this expected QV behavior, or recently modified QV behavior? I'm surprised I've never noticed this before!