topic Re: Based on Level of a hierarchy, display a specific column in App Development

Based on Level of a hierarchy, display a specific column

MrAndrews — Sat, 16 Nov 2024 05:33:39 GMT

I have a drill in a qlik sense app - I am able to identify what level i am at in the drill (=GetObjectField(0)), but based on that i want to be able to output a specific field.

I have tried all the options i can think of!

=if(GetObjectField(0) = 'Hierarchy2' , 'Correct level', 'Not at this level') - this returns 'Correct level'

=if(GetObjectField(0) = 'Hierarchy2' , [H2_DriverName], 'Not at this level')- this returns 'Not at this level'

So in the example below the required output would be whatever is in H2_DriverName. If the user drills further it would go to H3, H4 etc.

Cheers!

Hierarchy2	=GetObjectField(0)	Required Output	H2_DriverName	H3_DriverName	H4_DriverName
Com AA	Hierarchy2	Oblong	Oblong	Rectangle	Cheese
GR BB	Hierarchy2	Circle	Circle	Banana	Lemon

Re: Based on Level of a hierarchy, display a specific column

sunny_talwar — Tue, 18 Jun 2019 11:25:16 GMT

Would you be able to share a sample to check this out

Re: Based on Level of a hierarchy, display a specific column

MrAndrews — Tue, 18 Jun 2019 11:57:11 GMT

Sure - it's in Qlik Server, so I can't get to it, but i mocked this up - it has the same behaviour.

Like I said - I want to output the values in the column, but I can't work out how to do that!

So if the user hasn't drilled yet, and is it Hierarchy2, then they should see the outputed values from H2_DriverName

Much appreciated.

Re: Based on Level of a hierarchy, display a specific column

sunny_talwar — Tue, 18 Jun 2019 12:19:19 GMT

Since this is a dimension... try this

=if(GetObjectField(0) = 'Hierarchy2', Aggr(H2_DriverName, H2_DriverName), 'Not H2')

Re: Based on Level of a hierarchy, display a specific column

MrAndrews — Tue, 18 Jun 2019 12:47:24 GMT

magnificent! So, as I am using Aggr(dimension, dimension) it brings back the single option for that field name?

Re: Based on Level of a hierarchy, display a specific column

MrAndrews — Tue, 18 Jun 2019 13:31:16 GMT

Actually, that does cause issues when I embed some more IF statements:
=if(GetObjectField(0) = 'Hierarchy2' , Aggr([H2_DriverName], [H2_DriverName]) ,
if(GetObjectField(0) = 'Hierarchy3' , Aggr([H3_DriverName], [H3_DriverName]) ,
if(GetObjectField(0) = 'Hierarchy4' , Aggr([H4_DriverName], [H4_DriverName])
)
)
)

Re: Based on Level of a hierarchy, display a specific column

MrAndrews — Tue, 18 Jun 2019 13:31:55 GMT

The above creates blank records at each level!

Re: Based on Level of a hierarchy, display a specific column

sunny_talwar — Tue, 18 Jun 2019 13:39:25 GMT

Not entirely sure why it does that... but can you check this

=if(GetObjectField(0) = 'Hierarchy2' , Aggr(NODISTINCT [H2_DriverName], [H2_DriverName]) , if(GetObjectField(0) = 'Hierarchy3' , Aggr(NODISTINCT [H3_DriverName], [H3_DriverName]) , if(GetObjectField(0) = 'Hierarchy4' , Aggr(NODISTINCT [H4_DriverName], [H4_DriverName]))))

Re: Based on Level of a hierarchy, display a specific column

MrAndrews — Tue, 18 Jun 2019 13:41:43 GMT

That sorts it. Thanks for helping!

Re: Based on Level of a hierarchy, display a specific column

sunny_talwar — Tue, 18 Jun 2019 13:42:57 GMT

Happy to help 🙂