topic Filter on list Box in QlikView

Filter on list Box

Thu, 26 Apr 2012 11:35:36 GMT

Hi,

I have a table filled of Items of different Type (A->B->C), each item has an item father of the above Type identify by the field IdFather

On my document i create one list by Type and i want that when i select a item in a list, the list father/son get actualized

Thx for any advice

Jason_Michaelides — Thu, 26 Apr 2012 11:40:00 GMT

Don't quite understand. Canyou post an example?

Thu, 26 Apr 2012 12:00:01 GMT

Ok here my Table :

LOAD * Inline [

ITEM_ID, ITEM_LIB, TYPE, ID_FATHER

1 , 'ITEM A1' , 'A', 0

2 , 'ITEM A2' , 'A', 0

3 , 'ITEM A3' , 'A', 0

4 , 'ITEM B1' , 'B', 1

5 , 'ITEM B2' , 'B', 1

6 , 'ITEM B3' , 'B', 2

7 , 'ITEM B4' , 'B', 2

8 , 'ITEM B5' , 'B', 3

9 , 'ITEM C1' , 'C', 4

10 , 'ITEM C2' , 'C', 4

11 , 'ITEM C3' , 'C', 5

12 , 'ITEM C4' , 'C', 6

13 , 'ITEM C5' , 'C', 6

14 , 'ITEM C6' , 'C', 7

15 , 'ITEM C7' , 'C', 8

];

And then i create 3 lists filled with the following expression :

My question is when i select an item in List A, i want the active selection of the list B get update with its ID_FATHER field

Hope to be clear