topic Re: show only selected values in Listbox in QlikView

show only selected values in Listbox

suren946 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Could some one help me to solve the below issue. I have a Listbox1(Queue) with values

Queue

Production Completed

UAT Testing Completed

Submitted for UAT Testing

Submitted for Packaging

and Listbox2(Complexity)

Complexity

Complex

Medium

Simple

I just want to hide excluded values from Listbox1(Queue) upon section on Listbox2(Complexity). Putting below expressions in Listbox1(Queue) didn't helped me to get expected output.

=Aggr(Queue,Queue)

=aggr(Only({<Queue >} Queue), Queue)

Re: show only selected values in Listbox

suepenick — Tue, 03 Apr 2018 16:30:24 GMT

I wouldn't hide them. They are greyed out and tell the story that there are none in the Medium groupfor submitted for Packaging and Production complete. We know that because we can see that. if you hid them, you don't know what you are missing.

Visually you can always understand the data presented. Training your users will help them see the big picture. If they can't see certain info, they won't understand and start asking why don't I see .....

Just my opinion based on alot of internal analysis of a very huge amount of QVD's, data sets, etc.

Re: show only selected values in Listbox

shiveshsingh — Tue, 03 Apr 2018 17:07:12 GMT

Can you try this?

Re: show only selected values in Listbox

ychaitanya — Tue, 03 Apr 2018 17:21:26 GMT

Don'u put this as an Additional expresssion on your 2nd Tab in Listbox Properties.

Use the same expr in the 1st tab of listbox properties under Field dropdown.

Hope that should work

Thanks

Re: show only selected values in Listbox

suren946 — Wed, 04 Apr 2018 04:53:35 GMT

Hi,

Thanks for your reply but my requirement is to remove the Grey area as well from the Listbox

Re: show only selected values in Listbox

suren946 — Wed, 04 Apr 2018 04:57:24 GMT

I tried below expressions with Listbox1(Queue) and i don't think we can put any expression under listbox properties under Field dropdown

=Aggr(Queue,Queue)

=aggr(Only({<Queue >} Queue), Queue)

Re: show only selected values in Listbox

suren946 — Wed, 04 Apr 2018 04:58:44 GMT

Thanks. I will try to educate customer to atleast some extent

Re: show only selected values in Listbox

ychaitanya — Wed, 04 Apr 2018 13:01:27 GMT

click on the field in the List box Properties... Expression will be at the end of the list ..

Select that and paste the above expression, you will get the result.