Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
subhohere
Contributor
Contributor

Drill down Path in Text Box

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.





1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

2 Replies
sunny_talwar

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

View solution in original post

subhohere
Contributor
Contributor
Author

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