Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
brindlogcool
Creator III
Creator III

Hide Excluded

Hi,

I want to show only the selected values in the list box. I have tried to use the hide excluded but the problem is it is not actually hiding it is in the grey colour and the space is not getting truncated.  Is there any other way to achive this using macros.

13 Replies
Not applicable

Voted for it almost 2 years ago and still waiting....

Not applicable

I too have a relevant problem with the Listbox.

How can I remove blank spaces from the listbox.

Listbox.png

Thanks,

Ananth

joaogoncalves
Partner - Contributor III
Partner - Contributor III

This is a Blank Space in Field, In that specific case you can try this:

IF(Len(TRIM([Field]))>0,[Field])

Or correct the field in load script.

isaako34
Contributor
Contributor

Thanks, it works for me.