Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Display Only the Highest Hierarchy in the table

Hi Team,

I would like to display only the highest level of hierarchy in my output.

Emp Master:

This has the employee number and the licenses they own

License:

This contains the License Master and the Higherarchy level.

Required Output:

This is the output I am looking for.Though Employee can own many Licensces I need only the Highest higherarchy details.

Is this possible by set analysis?

Or do we need to do only in the datamodel

Need youe help on this

Thanks & Regards

Jeba

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Sorry Jeba,

I don't know if I have understood..

Can you try with this?

aggr(min(Hierarchy), [Emp Code])

View solution in original post

9 Replies
Anonymous
Not applicable
Author

Hi Team,

Could you please help me

Regards

Jeba

Anonymous
Not applicable
Author

Hello!

I see that if you create a straigth table with Emp Code as dimension, you can use just min(Hierachy) as expression: the output of this is like the one you want.

Let me know

Anonymous
Not applicable
Author

Hi Elena,

It almost worked except if I add one more dimension to it then it is not only fetching min but it fetches all values

Is there any quick fix you can offer me?

Regards

Jeba

Anonymous
Not applicable
Author

Can you upload your excel with the new dimension?

In this way it's more simple for us!

Thanks!

Anonymous
Not applicable
Author

Hi Elena,

Please find the same.

I have highlighted the column in yellow for your kind reference

Regards

Jeba

Anonymous
Not applicable
Author

Sorry Jeba,

I don't know if I have understood..

Can you try with this?

aggr(min(Hierarchy), [Emp Code])

Anonymous
Not applicable
Author

Hi Elena,

It worked and you are Great.

Thanks & Regards

Jeba

Anonymous
Not applicable
Author

WAIT!!!!

11113 has a problem.. hasn't it??

Is it ok for you? I see: Licence name 2,5-  instead of 2, even if Hierarchy is ok.


Anonymous
Not applicable
Author

Hi Elena,

Thanks for highlighting this.

Actually it was a typo error from my dymmay data.

My actual scanario works perfect by your code and thanks a lot for that

Thanks & Regards

Jeba