Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
Not applicable

Multiple column header values into a listbox

Hello,

Can anyone please help me to achieve the result shown here? The data is available as different columns and i would need to display a filter with the header values.(Listbox or Multibox etc.). Thanks.

Fruits
Apple
Orange
Pear
Banana

Vegetables
Carrot
Beans
Cabbage

ListBox
Fruits
Vegetables
8 Replies
Not applicable

Re: Multiple column header values into a listbox

I am not sure what you want. That means a list box to contain the three fields with filter selection? The easiest way to display is create a container and put the three list boxes in it. Using display option "single object", "tabs on top". I am not sure if this can help you!

vikky
Contributor III

Re: Multiple column header values into a listbox

Hi...Check this out..

Hierarchy in QlikView

Re: Multiple column header values into a listbox

Create a Inline table with all the required field name and a list box for the same

migueldelval
Valued Contributor

Re: Multiple column header values into a listbox

Hi Gamavidy,

Try this example please.

Regards

Miguel del Valle

Partner
Partner

Re: Multiple column header values into a listbox

Hi,

You also try this attachment,

25.JPG

Not applicable

Re: Multiple column header values into a listbox

Head Count
0-1000
1001-5000
5001-10000

Thank you all for the response.

But my requirement is different, i should have used a different example.

New example: Please help me out here.

Load

Department,

0-1000,

1001-5000,

5001-100001

From Sample.xls.

In the above Load statement fields 0-1000, 1001-5000 are the number of employees in a particular department.

i would like to display the ranges in a list box or a multi box as a filter.

MVP
MVP

Re: Multiple column header values into a listbox

try the attachment

Not applicable

Re: Multiple column header values into a listbox

Thanks for your efforts Maxgro, however my requirement is different.

I have the values calculated and available as columns, eg: Column Header: 0-1000, Values inside it: 4,5,10, 20 etc. Similarly for other Ranges too. I just want to display these column headers as filters. I could not find a better way to explain this