Discussion Board for collaboration related to QlikView App Development.
I have a requirement where I have to show the data in treeview.
Attached is the sample data.
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,