Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
de
Contributor II
Contributor II

How do I put vertical lines on a horizontal listbox and how do I limit the values on the listbox?

I have a horizontal listbox with months like so:
JAN    FEB    MAR ....
and i want to make it show up like this:
JAN   |    FEB    |    MAR ...

But the only borders I can place are bottom borders.

Also I would like to display only a few values from another listbox
Instead of                 I need
       a                                 a
       b                                 c
       c
       d

I hope you understand and thank you!

Labels (3)
2 Replies
Claudiu_Anghelescu
Specialist
Specialist

For the second question write in Expression:
=if(Match(Field, 'a','c') >0, Field)
To help community find solutions, please don't forget to mark as correct.
Brett_Bleess
Former Employee
Former Employee

I knew there was a way to do this, but I could not remember, finally found it today! 🙂  Attached is a screenshot for you, that should do the trick if you set the properties as I highlighted in yellow, the main thing is the 'Single Column' check box needs to be unchecked, then when you expand the Listbox object, things should spread out and automatically put the | between the values as well I believe.  Hopefully this works for you in that regard.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.