topic Re: Qlik concat fields based on measure values in App Development

Qlik concat fields based on measure values

Shivam22 — Tue, 14 Oct 2025 14:57:47 GMT

Hello All,

I have a table like below

ID Date Country Value

1 2/3/2025 Argentina 0

1 2/3/2025 Mexico 100

when i use function concat(Country, ',') and used as expression in above table i get below result

ID Date Country Value

1 2/3/2025 Argentina,Mexcio 100

but i want the result like below where Mexioc should come first then Argentina since Mexico has value

ID Date Country Value

1 2/3/2025 Mexcio,Argentina 100

Can anyone please help!

Thanks in Advance!

robert_mika — Tue, 14 Oct 2025 15:08:48 GMT

There is another parameter you can use.

Look at Qlik help or here

Chanty4u — Tue, 14 Oct 2025 15:09:27 GMT

Try this

Concat(DISTINCT Country, ', ', -Value)

Shivam22 — Tue, 14 Oct 2025 15:34:31 GMT

Thanks @Chanty4u it works,

When i have data like below
ID Date Country Value

1 2/3/2025 Argentina 0

1 2/3/2025 Mexico 100

1 2/3/2025 Mexico 200

Gives me result

1 2/3/2025 Mexico,Mexico,Argentina 300

How can we get Mexico value only once?

1 2/3/2025 Mexico,Argentina 300

Thanks Alot

robert_mika — Tue, 14 Oct 2025 15:49:31 GMT

Maybe

Concat(DISTINCT Country, ', ', aggr((-Value), Country))

Shivam22 — Tue, 14 Oct 2025 16:01:58 GMT

For some reason the result is like below, Mexio is repeating 3 times

1 2/3/2025 Mexico,Mexico,Mexico,Argentina 300

Thank You!