Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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.