Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
chinmei
Contributor
Contributor

How to separate the measures in another like and add in further text

Hi, 

I am using Text  & Image in my qlik sheet. I had created 2 measures. They are:

measure 1 - concat(DISTINCT(field1))

measure 2 - Sum({<field2 = {'$(field3 & field4)'}>} field5) and the output is 'ABC Factory0.00'

Is it possible to format it in a way that would become 

ABC Factory

Output: 0.00 MG?

Rgds,

Chin Mei

 

Labels (2)
1 Reply
Or
MVP
MVP

You can add text, formatting, and spacing between measures, e.g.:

Or_0-1661936905167.png

 

Or_1-1661936923370.png