topic Re: Grouping specific items in a ListBox in QlikView

Grouping specific items in a ListBox

Sun, 24 Jan 2016 14:52:35 GMT

Hello I am new to this community, thanks in advance for any insight.

I have a list box with different Tasks Numbers (which are coming from an excel file). Each Tasks has an owner (the owner - task relationship isn't listed anywhere). I'd like to be able to Select an owner, and automatically see the tasks owned.

List Box Tasks:
Task 1
Task 2
Task 3

Task 4

I know that John owns Task 1, 2, 3, and Bob is the owner of Task4. How can I create a dropdown or a filter which will let me select on "Bob", and I would only see Task1, Task2, Task3? Im open to using expressions, or creating a new object, or dealing with this at the script level.

Thanks!

Re: Grouping specific items in a ListBox

sunny_talwar — Sun, 24 Jan 2016 16:12:07 GMT

It depends on how your data model is structured? Is it something like this?

Owner, Task

John, Task 1

John, Task 2

John, Task 3

Bob, Task 4

If they are somehow linked to each other, you can use a text box or any other chart object to show the relationship. Where exactly are you trying to do this?

Re: Grouping specific items in a ListBox

maxgro — Sun, 24 Jan 2016 16:40:00 GMT

Add another table to your model (replace YourTaskTable and YourTaskField with the name of the already loaded task table and task field from excel) to make the task - owner relationship

left join (YourTaskTable)

load * inline [

Owner, YourTaskField

John, Task 1

John, Task 2

John, Task 3

Bob, Task 4

];

add a listbox with the Owner field

You can do the same adding a sheet to your excel with the relationship and loading the 2 sheets (task, task-owner relationship) from excel into Qlik.

Re: Grouping specific items in a ListBox

Sun, 24 Jan 2016 17:06:32 GMT

This worked like a charm! Thank you very much. This was helpful and taught me how to manipulate tables at the script level.

Re: Grouping specific items in a ListBox

maxgro — Mon, 25 Jan 2016 08:22:33 GMT

you can learn a lot (for script level) from this doc

LOAD data into QlikView