topic Alignment with Concat in QlikView

Alignment with Concat

reshmakala — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I have a concat statement where I need to show 3 fields in a text box well aligned. Can anyone please help me with this?

Attached is the sample qvw.

sunny_talwar — Wed, 26 Oct 2016 14:43:46 GMT

You can try this, but this isn't perfect also:

=Concat(DISTINCT Name&' | '&Dept&Repeat(' ', Aggr(Max(TOTAL Len(Dept)) - Len(Dept), Dept))&' | '&Location,Chr(10))

rubenmarin — Wed, 26 Oct 2016 14:45:00 GMT

Hi Reshma, you can use something like:

=Concat(DISTINCT Name& Repeat(' ', 20-Len(Name)) & ' | '&Dept& Repeat(' ', 10-Len(Dept)) &' | '&Location,Chr(10))

//Change '20' and '10' the the max length value for each field.

But unsless you use a monospaced font like courier it wouldn't work as each character can have a different width.

sunny_talwar — Wed, 26 Oct 2016 14:46:19 GMT

What I am doing here is to find the max length of the dept and then repeat an empty space for difference in length of each department.

So, for example, since sales is 5 character long and HR is 2 character, the above expressions adds 3 extra spaces in the text box

sunny_talwar — Wed, 26 Oct 2016 14:48:15 GMT

Changing it to Courier did help

reshmakala — Wed, 26 Oct 2016 14:54:29 GMT

Thank you for your help Sunny. I am actually trying to implement this in the alert section. My email alerts are unaligned.

reshmakala — Wed, 26 Oct 2016 15:01:52 GMT

I am actually trying to implement this in the alert section. My email alerts are unaligned.