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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
jjustingkm
Creator II
Creator II

Create a single cell in qlik

Is there a way to have a single cell in Qlik like below where I can can include a dimension with only value. When I use Text and Image I was not able to include dimension inside.

jjustingkm_1-1750275983543.png

 

 

Labels (1)
4 Replies
vkramBI4Qlik
Contributor III
Contributor III

You can do in many different ways.

Below is one way , Is this what you are looking for ?

Text Object Edit Mode :

vikram234_0-1750343809361.png

View Mode :

vikram234_1-1750343892733.png

 

Thanks 

Vikram

 

Aditya_Chitale
Specialist
Specialist

@jjustingkm 

you can achieve this using getfieldselections() function in a KPI.

=getfieldselections(Dimension_Name)


Regards,

Aditya

jjustingkm
Creator II
Creator II
Author

I have noticed that, but you have only option to add a measure here correct, for example if the dimensions have multiple values comma separated, would it work?

vkramBI4Qlik
Contributor III
Contributor III

Then for your requirement , you can change the expression to follows

CONCAT(DISTINCT Dim1,', ') 

or

CONCAT(DISTINCT AGGR(Dim1,Dim1) ,', ')

thanks

Vikram