topic Re: Display Only the Highest Hierarchy in the table in QlikView

Display Only the Highest Hierarchy in the table

Anonymous — Tue, 20 Jan 2015 13:20:27 GMT

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

Re: Display Only the Highest Hierarchy in the table

Anonymous — Tue, 20 Jan 2015 14:42:36 GMT

Hi Team,

Could you please help me

Regards

Jeba

Re: Display Only the Highest Hierarchy in the table

Anonymous — Tue, 20 Jan 2015 15:04:30 GMT

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

Re: Display Only the Highest Hierarchy in the table

Anonymous — Tue, 20 Jan 2015 16:44:07 GMT

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

Re: Display Only the Highest Hierarchy in the table

Anonymous — Tue, 20 Jan 2015 16:46:55 GMT

Can you upload your excel with the new dimension?

In this way it's more simple for us!

Thanks!

Re: Display Only the Highest Hierarchy in the table

Anonymous — Tue, 20 Jan 2015 16:53:26 GMT

Hi Elena,

Please find the same.

I have highlighted the column in yellow for your kind reference

Regards

Jeba

Re: Display Only the Highest Hierarchy in the table

Anonymous — Tue, 20 Jan 2015 17:02:11 GMT

Sorry Jeba,

I don't know if I have understood..

Can you try with this?

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

Re: Display Only the Highest Hierarchy in the table

Anonymous — Tue, 20 Jan 2015 17:09:07 GMT

Hi Elena,

It worked and you are Great.

Thanks & Regards

Jeba

Re: Display Only the Highest Hierarchy in the table

Anonymous — Tue, 20 Jan 2015 17:12:20 GMT

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.

Re: Display Only the Highest Hierarchy in the table

Anonymous — Tue, 20 Jan 2015 17:19:34 GMT

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