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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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)
1 Solution

Accepted Solutions
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

View solution in original post

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