Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Filter on list Box

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

2 Replies
jason_michaelid
Honored Contributor II

Filter on list Box

Don't quite understand.  Canyou post an example?

Not applicable

Filter on list Box

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 :

  • if (TYPE='A',ITEM_LIB)
  • if (TYPE='B',ITEM_LIB)
  • if (TYPE='C',ITEM_LIB)

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

Community Browser