Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist
Specialist

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

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.
Highlighted
Digital Support
Digital Support

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

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.