Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

Filter and drill down issue

Hi everybody!

Need you guidance

I have the Hierarchy table with 4 Nodes and some connected Fact table with it.

The Specificity of the task is to show every of 4 nodes with fact values in 4 separate stright tables, as it is done on the pic below.

1.png

As is:

When I "drill" the tree in such way i see all the possible values in nodes(parent and child).

For example, I have selected

step1: "Indicator3" in Node_name1

step2: "Indicator3.2" in Node_name2

step3: "Indicator3.2.1" in Node_name3


and it is ok.

2.png

But after this, when i select another value


step 4: "Indicator3.1" in Node_name2


all maded selections (particulary in Node_name1) fail, because the selected value

"Indicator3.1" in Node_name2

is incompatible  with selected child before

"Indicator3.2.1" in Node_name3

but compatible with selected parent "Indicator3" in Node_name1.

3.png


To be result: after step4 selection (all parents are remain selected and dont fail)


4.png


I have tryed some triggers, locking fields, but havn't achieved the desired result (


Are there any aproaches to keep all parent nodes selected?

The qwv. file is attached.


Look forward to you reply

Thanks


1 Reply
vishsaggi
Esteemed Contributor III

Re: Filter and drill down issue

Did you try Set Clear State from Selections tab. ?

And in your Node3 and Node 4 straight tables, uncheck Supress Missing option from Presentation tab.