Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
FLASH SALE: Save $500! Use code FLASH2026 at checkout until Feb 14th at 11:59PM ET. Register Now!
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..

Labels (1)
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])