Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
pinky1234
Contributor III
Contributor III

Display dimension values in Text object

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. 

LocationRankRack
Michigan111A
Ohio121B
California131C
Chicago141D
Labels (2)
1 Solution

Accepted Solutions
MayilVahanan

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, ','), '')


Thanks & Regards,
Mayil Vahanan R

View solution in original post

5 Replies
Kushal_Chawda

@pinky1234  you can simple call, =Location text object

pinky1234
Contributor III
Contributor III
Author

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

QFabian
Specialist II
Specialist II

hi, in a text object try :

=only(Location)

 

as is possible to have more than one Michigan value location

QFabian
pinky1234
Contributor III
Contributor III
Author

I tried only function and it didnt work.

MayilVahanan

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, ','), '')


Thanks & Regards,
Mayil Vahanan R