Drill down Path in Text Box

[subhohere]

Hi Qlik Gurus,

Can anyone help me with a way out how can I show the drill down path in text box. I tried with the below code.

=GetFieldSelections(Name) & '/' & GetFieldSelections([Group 1])& '/' & GetFieldSelections([Group 2])& '/' & GetFieldSelections([Group 3])& '/' & GetFieldSelections([Group 4])& '/' & GetFieldSelections([Group 5])& '/'& GetFieldSelections([Desc])

but there is a challenge, the slashes show up if the drill down is not used. Once I go to the last drill down everything looks perfect.

What I want:

Name/Surname/Group 1/Group 2/Group 3/Group 4/Group 5/Desc.

Once I go up the drill down option. it should be like:

Name/Surname/Group 1/Group 2

and not

Name/Surname/Group 1/Group 2////

Any quick help will be much appreciated.

[sunny_talwar · Accepted solution]

May be this

=

GetFieldSelections(Name) & If(GetSelectedCount([Group 1]) > 0, '/') &

GetFieldSelections([Group 1]) & If(GetSelectedCount([Group 2]) > 0, '/') &

GetFieldSelections([Group 2]) & If(GetSelectedCount([Group 3]) > 0, '/') &

GetFieldSelections([Group 3]) & If(GetSelectedCount([Group 4]) > 0, '/') &

GetFieldSelections([Group 4]) & If(GetSelectedCount([Group 5]) > 0, '/') &

GetFieldSelections([Group 5]) & If(GetSelectedCount(Desc) > 0, '/') &

GetFieldSelections([Desc])

[subhohere]

Perfecto awesome ... that's what I am looking for. thanks a ton Sunny.