Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
unknownb
Partner - Contributor III
Partner - Contributor III

Replace Concat'd Value

I am needing help with an ongoing issue.

I am pulling a field where the result is the ID being pulled rather than the text, and if multiple have been selected at the input stage it becomes concatted. 

I need to change these ID's back to text, I was hoping to use the replace( but getting a little confused here.

Dimension: =IF(contract_field_title = 'Please specify which currency' and answerLatest = 'Yes', contract_field_answer_value)

Current Result: 182,184

Desired Result: GBP,USD

Where multiple fields have that title we are using the following expression: 
=concat(distinct(IF(contract_field_title = 'Please specify which currency' and answerLatest = 'Yes', contract_field_answer_value)), ',')

Current Result: 182,134,242

Desired Result: GBP,USD,AUD

How would I achieve this?

10 Replies
unknownb
Partner - Contributor III
Partner - Contributor III
Author

Hello Steve,

The problem is we have a load script which is templated across a number of different sites and client data within. We want to steer away from having custom load scripts for sites and have one 'template' if you like so we have to do these in the front end.

But yes, for now it is working using the long method i have mentioned, thanks for your help.