Has a recent hierarchy thread been satisfied or deleted?

evan_kurowski — Sun, 04 Oct 2015 16:48:37 GMT

I recently took the time to research & assemble the following response for a Qlik Community user having issue with forming hierarchies with a delimited '>' chain. He wanted to select nodes at a specific level and have interface objects toggle based on that.

After forming this post, the thread disappeared. So is the question answered? Or was the thread deleted?

Your hierarchy shows 4 tiers and you name them: Corporate, Segment, Sub, & Site

It appears your initial expressions has some issues. There appears to be attempts to form matches between different hierarchy levels, and the usage of the GetFieldSelections() function needs a field name as an argument (you are passing it a formed string).

upper(SubField([HFM Entity],'>',2) is going to extract the tails of [HFM Entity] entries from Segment, Sub, & Site and you are attempting to match this on entries in [Corporate].

Since [Corporate Entity] is the first layer of your hierarchy you need Subfield([HFM Entity],'>',1)

In your matching expressions. Unless you misworded your question and you really want to match on the 2^nd tier of your hierarchy which is by ‘Segment’

However, I would point out that your initial description does not make it clear what is happening between the fields [HFM Entity] & [Corporate Entity Name].

These two fields could easily be associated in a single table, and having them so would simplify the UI expressions to do what you are attempting.

Maybe take a look at the two examples below and expand your description of which structure you have in your data model, as it would clarify the approach for anyone attempting to assist.

//** Unassociated HFM Entity to Corporate Entity Name

//** more complex UI expressions needed because nothing is joined or within same table

LOAD * INLINE [
HFM Entity
A > B > C
A > B
F > G
F > G > H
];

LOAD * INLINE [
Segment Entity Name
B
G
];

LOAD * INLINE [
Corporate Entity Name
A
F
];

//** Associated HFM Entity to Corporate & Segment
//** less complex UI expressions needed

LOAD * INLINE [
Corporate Entity Name, Segment Entity Name, HFM Entity, Depth
A, B, A > B > C, 3
A, B, A > B, 2
F, G, F > G, 2
F, G, F > G > H, 3
];

Re: Has a recent hierarchy thread been satisfied or deleted?

toucangulyayu — Wed, 14 Oct 2015 02:16:32 GMT

Eso era mío Evan, lo siento por eso. Era grosero de mi parte pedir a su tiempo y luego abandonar este hilo. Vaya por delante y marcarlo correcta. ~Toucan

Re: Has a recent hierarchy thread been satisfied or deleted?

evan_kurowski — Wed, 14 Oct 2015 20:14:40 GMT

Khom Pewter <span class="icon-status-icon icon-partner" title="Partner"></span> wrote:

Eso era mío Evan, lo siento por eso. Era grosero de mi parte pedir a su tiempo y luego abandonar este hilo. Vaya por delante y marcarlo correcta. ~Toucan

Appreciate that, thanks.

topic Has a recent hierarchy thread been satisfied or deleted? in QlikView

Has a recent hierarchy thread been satisfied or deleted?

Re: Has a recent hierarchy thread been satisfied or deleted?

Re: Has a recent hierarchy thread been satisfied or deleted?