
Contributor
2022-08-31
05:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
326 Views
1 Reply


MVP
2022-08-31
05:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can add text, formatting, and spacing between measures, e.g.:
