Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Problem with a association / build a new key?

Hi

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!

1 Solution

Accepted Solutions
Not applicable

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

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

2 Replies
Not applicable

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

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

Not applicable

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

Thanks!

Community Browser