Hierarchy Load - Issue in filtering data

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a requirement where I have to show the data in treeview.

Attached is the sample data.

NodeID	ParentID	Value	Overall_Percentage	Within_Percentage	Level	Filter1	Filter2
1		Value1 has Overall 99.57 and within 100	99.57	100	1	10	0
2		Value2 has Overall 87.46 and within 38.47	87.46	38.47	1	12	0
3		Value3 has Overall 39.36 and Within 37.26	39.56	37.26	1	12	1
4	1	Value4 has Overall 14.49 and within 29.38	14.49	29.38	2	11	1
5	2	Value 5 has Overall 46.56 and Within 47.38	46.56	47.38	2	10	0
6	1	Value6 has Overall 75.68 and Within 43.57	75.68	43.57	2	12	0
7	2	Value7 has Overall 96.56 and Within 49.29	96.56	49.29	2	10	0
8	3	Value8 has Overall 56.89 and Within 19.99	56.89	19.99	2	11	1
9	3	Value9 has Overall 36.46 and Within 47.66	36.46	47.66	2	12	1
10	2	Value10 has Overall 38.26 and Within 1.47	38.26	1.47	2	11	1
11	5	Value11 has Overall 90.35 and Within 3.33	90.35	3.33	3	10	0
12	4	Value12 has Overall 27.36 and Within 59.66	27.36	59.66	3	12	1
13	9	Value13 has Overall 99.87 and Within 9.27	99.87	9.27	3	10	0
14	5	Value14 has Overall 32.46 and Within 10.23	32.46	10.23	3	10	0
15	10	Value15 has Overall 35.47 and Within 13.3667	35.47	13.3667	3	11	1
16	7	Value16 has Overall 42.16 and Within 27.38	42.16	27.38	3	12	1
17	8	Value17 has Overall 53.89 and Within 47.27	53.89	47.27	3	10	0
18	9	Value18 has Overall 65.27 and Within 1.33	65.27	1.33	3	12	0
19	7	Value19 has Overall 82.46 and Within 3.58	82.46	3.58	3	11	1
20	9	Value20 has Overall 61.36 and Within 19.26	61.36	19.26	3	12	0

I have to filter/select the data based on an range of Percentage (Overall_Percentage field to be used)

First it should filter on level 1 then on Level 2 and then on Level3.

I have selected the range >80.

The result is coming out to be

Expected is :

If the Overall_Percentage range is available in Level=1 then only it should show value at Level=1 else not (Value3 and its tree beyond should not be shown),

if the Overall_Percentage range is available in Level=1 first and then Level=2 then it should show value at Level=2 else not (Value5 and its tree beyond should not be shown),

if Overall_Percentage range is available in Level=1 and then Level=2 and then Level=3, then its should show the Value at Level=3

Pls help or suggest any way to achieve this.

Attached the required qvw and sample data.

Thanks and Regards,

Anjali Gupta

topic Hierarchy Load - Issue in filtering data in QlikView

Hierarchy Load - Issue in filtering data