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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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