topic Re: Concatenation Issue in QlikView

Concatenation Issue

principal — Sat, 16 Nov 2024 20:12:31 GMT

Hi,

I have the following expression

=Concat(If(Len(Trim(Aggr($(e.appointments), [Appointment Priority]))) > 0, [Appointment Priority] & ' - ')

& trim(Aggr($(e.appointments), [Appointment Priority])),chr(13))

with the following result

how do I remove the first - 0

Re: Concatenation Issue

Vegar — Wed, 04 Sep 2019 14:41:51 GMT

I added a set modifier to your outer concat.

=Concat({<[Appointment Priority]*={"*"}>}If(Len(Trim(Aggr($(e.appointments), [Appointment Priority]))) > 0, [Appointment Priority] & ' - ')

& trim(Aggr($(e.appointments), [Appointment Priority])),chr(13))

Re: Concatenation Issue

Brett_Bleess — Wed, 04 Sep 2019 14:02:45 GMT

Alan, did Vegar's post help you resolve things? If so, please be sure to give him credit due by using the Accept as Solution button on his post, this will also let others know the solution worked as well.

Regards,
Brett

Re: Concatenation Issue

principal — Thu, 05 Sep 2019 08:12:00 GMT

Thanks Vegar, it works perfectly.