topic Re: Problem with a association / build a new key? in QlikView

Problem with a association / build a new key?

Mon, 27 Aug 2012 09:15:30 GMT

I have a excelfile that are build as follow.

LOAD

* INLINE [
ID, Work,                          Edu
1, Admin
1, Construction
1,                                    , Economic
1,                                    , Kindergarden
2,                                     , University
2, Teacher
3, Teacher
3,                                      , Higher math
]

In a table/chart I want to click on Education = Economic and then also get what type of work the ID has, or click on Teacher and get what kind of education they have. The same thing that happens if i click on the ID itself but I don´t wont to show the ID... So, how can I associate them to each other, some way build a new key?

How can this be done?

Thanks!

Re: Problem with a association / build a new key?

Mon, 27 Aug 2012 12:37:18 GMT

Hello,

I have build something. I hope it is what you are looking for.

I have change your INLINE a bit. So the peek-function can always look at the predecessor. Then you can use the hierarchy load - function, if you want.

Regards

Vicky

Re: Problem with a association / build a new key?

Mon, 27 Aug 2012 15:22:21 GMT

Thanks!