Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
paulwalker
Creator III
Creator III

Display in Textbox

Hi Community,

I need to show Navigation in Textbox...

I have one Drill Down group

Division-->Category-->Product

This Drilldown group i took in Listbox..

If i am select Division drill into Category drill into Product.

Exapmle:

These 3 dimension are in One DrillGroup

Capture.JPG

I want show this navigation in Textbox...

Europe-->Sportwear-->Basket Vest

PFA

Thanks in Advance..

5 Replies
varshavig12
Specialist
Specialist

Can you post a screenshot of what you want

as I'm using personal edition.

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Simply use Table box with all 3 Dimensions.

ankit777
Specialist
Specialist

try this

=Divisonname&'->'&Category&'->'&Productname

jonathandienst
Partner - Champion III
Partner - Champion III

If you need to show the drill path selections only:


If(GetSelectedCount(DivisionName) = 1, DivisionName, '') & '-->' &

If(GetSelectedCount(Category) = 1, Category, '') & '-->' &

If(GetSelectedCount(ProductName) = 1, ProductName, '')

If you want to show the possible values (implied by selections on other fields):

If(GetPossibleCount(DivisionName) = 1, DivisionName, '') & '-->' &

If(GetPossibleCount(Category) = 1, Category, '') & '-->' &

If(GetPossibleCount(ProductName) = 1, ProductName, '')

If you want to show something other than an empty string when there is no distinct selected or possible values, replace the empty strings ('').

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
florentina_doga
Partner - Creator III
Partner - Creator III

use

=GetCurrentField([Navigation])