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: 
samp
Contributor III
Contributor III

Display Table Field values in Text box

I have table with distinct values as below, I need to display all rows in the text box as below, thanks for your help.

load * inLine [
CCode,Month
USA,Aug-2020
CAD,Sep-2020
];

Expected Output in TextBox:

USA:Aug-2020 ; CAD:Sep-2020

 

Labels (2)
1 Solution

Accepted Solutions
Taoufiq_Zarra

Hi,

One solution, in text the expression :

=concat(CCode&':'&Month,';')

 

output :

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

1 Reply
Taoufiq_Zarra

Hi,

One solution, in text the expression :

=concat(CCode&':'&Month,';')

 

output :

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉