Solved: Re: Concatenation Issue - Qlik Community

principal · ‎2019-08-23

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

Vegar · ‎2019-08-23

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))

Vegar
Qlik Community MVP

View solution in original post

Vegar · ‎2019-08-23

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))

Vegar
Qlik Community MVP

Brett_Bleess · ‎2019-09-04

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

principal · ‎2019-09-05

Thanks Vegar, it works perfectly.

Concatenation Issue

Concat

expresison