topic Re: Multiple column header values into a listbox in QlikView

Multiple column header values into a listbox

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Multiple column header values into a listbox

Wed, 29 Jun 2016 07:08:28 GMT

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!

Re: Multiple column header values into a listbox

vikramv — Wed, 29 Jun 2016 07:12:04 GMT

Hi...Check this out..

Hierarchy in QlikView

Re: Multiple column header values into a listbox

avinashelite — Wed, 29 Jun 2016 07:12:24 GMT

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

Re: Multiple column header values into a listbox

migueldelval — Wed, 29 Jun 2016 07:14:55 GMT

Hi Gamavidy,

Try this example please.

Regards

Miguel del Valle

Re: Multiple column header values into a listbox

susovan — Wed, 29 Jun 2016 08:38:05 GMT

Hi,

You also try this attachment,

Re: Multiple column header values into a listbox

Wed, 29 Jun 2016 17:36:39 GMT

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.

Re: Multiple column header values into a listbox

maxgro — Wed, 29 Jun 2016 19:42:10 GMT

try the attachment

Re: Multiple column header values into a listbox

Wed, 29 Jun 2016 21:24:13 GMT

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