Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 2nd 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
];
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.
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
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.