topic Re: Display in Textbox in QlikView

Display in Textbox

paulwalker — Wed, 25 Nov 2020 16:16:04 GMT

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

I want show this navigation in Textbox...

Europe-->Sportwear-->Basket Vest

PFA

Thanks in Advance..

varshavig12 — Wed, 22 Jun 2016 05:29:36 GMT

Can you post a screenshot of what you want

as I'm using personal edition.

MindaugasBacius — Wed, 22 Jun 2016 05:35:58 GMT

Simply use Table box with all 3 Dimensions.

ankit777 — Wed, 22 Jun 2016 05:39:49 GMT

try this

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

jonathandienst — Wed, 22 Jun 2016 07:02:27 GMT

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 ('').

florentina_doga — Wed, 22 Jun 2016 07:18:24 GMT

use

=GetCurrentField([Navigation])