I have a requirement where I have to show the data in treeview.
Attached is the sample data.
|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,