topic Re: Drill down Path in Text Box in QlikView

Drill down Path in Text Box

subhohere — Thu, 24 May 2018 11:28:00 GMT

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.

Re: Drill down Path in Text Box

sunny_talwar — Tue, 29 May 2018 16:27:34 GMT

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])

Re: Drill down Path in Text Box

subhohere — Thu, 31 May 2018 08:42:51 GMT

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