Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

paulwalker
Contributor

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
Valued Contributor

Re: Display in Textbox

Can you post a screenshot of what you want

as I'm using personal edition.

MindaugasBacius
Valued Contributor III

Re: Display in Textbox

Simply use Table box with all 3 Dimensions.

ankit777
Valued Contributor

Re: Display in Textbox

try this

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

MVP
MVP

Re: Display in Textbox

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
Partner
Partner

Re: Display in Textbox

use

=GetCurrentField([Navigation])