topic Re: Display dimension values in Text object in QlikView

Display dimension values in Text object

pinky1234 — Fri, 15 Nov 2024 23:46:18 GMT

Hi,

I have data like in table below. I want to display location in Text object like if you select rank 111 or Rack or any associated field from search object text object should show location as Michigan, Select 121 show Ohio, Select 131 show California..etc. If i don't select anything show text objects as empty.

Location	Rank	Rack
Michigan	111	A
Ohio	121	B
California	131	C
Chicago	141	D

Re: Display dimension values in Text object

Kushal_Chawda — Tue, 20 Oct 2020 16:44:06 GMT

@pinky1234 you can simple call, =Location text object

Re: Display dimension values in Text object

pinky1234 — Tue, 20 Oct 2020 17:08:59 GMT

I tried that way and it didn't work. Even i tried Concat function but all locations are showing in text object.

Re: Display dimension values in Text object

QFabian — Tue, 20 Oct 2020 17:13:43 GMT

hi, in a text object try :

=only(Location)

as is possible to have more than one Michigan value location

Re: Display dimension values in Text object

pinky1234 — Tue, 20 Oct 2020 17:16:09 GMT

I tried only function and it didnt work.

Re: Display dimension values in Text object

MayilVahanan — Wed, 21 Oct 2020 09:44:52 GMT

Hi @pinky1234

Might be, you have more than one location per rank or rack.
Try like below

=if(GetselectedCount(Rank)=1 or GetSelectedCount(Rack)=1, Count(Distinct Location, ','), '')