Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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])
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])
Perfecto awesome ... that's what I am looking for. thanks a ton Sunny.