Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
jebamalai
Specialist
Specialist

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
elena888
Specialist
Specialist

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
jebamalai
Specialist
Specialist
Author

Hi Team,

Could you please help me

Regards

Jeba

elena888
Specialist
Specialist

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

jebamalai
Specialist
Specialist
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

elena888
Specialist
Specialist

Can you upload your excel with the new dimension?

In this way it's more simple for us!

Thanks!

jebamalai
Specialist
Specialist
Author

Hi Elena,

Please find the same.

I have highlighted the column in yellow for your kind reference

Regards

Jeba

elena888
Specialist
Specialist

Sorry Jeba,

I don't know if I have understood..

Can you try with this?

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

jebamalai
Specialist
Specialist
Author

Hi Elena,

It worked and you are Great.

Thanks & Regards

Jeba

elena888
Specialist
Specialist

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.


jebamalai
Specialist
Specialist
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