topic Re: Help to create hierarchy field in App Development

Help to create hierarchy field

micheledenardi — Thu, 15 Mar 2018 13:25:09 GMT

Hi experts,

i've got a simple table like below where i've stored a list of numbers.

Tab1:

Number
1
2
3
4
5
6
7
8
9

I want to create one new field in order to use as filter where if i select:

"All numbers equal minors of 2" my Tab1 filters 1 and 2 numbers;
"All numbers equal minors of 5" my Tab1 filters 1,2,3,4 and 5;
And so on

How to achieve this by using an elegant solution ? Maybe hierarchy() function could be the correct way but i didn't understand how to write the code...

Thanks

Re: Help to create hierarchy field

YoussefBelloum — Thu, 15 Mar 2018 14:19:27 GMT

Hi,

you can try this:

pick(match(-1,Number>=1 and Number<=5,Number>5 and Number<=9), 'All numbers equal minors of 5','All numbers equal minors of 9') as label

PFA

Re: Help to create hierarchy field

Digvijay_Singh — Thu, 15 Mar 2018 14:19:30 GMT

Not an elegant one but simple solution specific to your sample problem, not sure if actual data is complex then this -

Re: Help to create hierarchy field

micheledenardi — Thu, 15 Mar 2018 14:58:16 GMT

How can i do the same things if my Tab1 contains text and not numbers ?

Es:

Tab1:

Header 1
Group A
Group B
Group C
Group D
Group E
Group F
Group G
Group H
Group I

So:

if i select "Group C" my table Tab1 shows Group A, Group B and Group C.
if i select "Group F" my table Tab1 shows Group A, Group B, Group C Group D, Group E and Group F.

Re: Help to create hierarchy field

Digvijay_Singh — Thu, 15 Mar 2018 15:07:17 GMT

The same logic works but you may like to have ID field in case real data is bit more complex.