uneven spacing between text

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

Hi Team

I've got a calculated dimension in a pivot table as below

=Date(due_date, 'WWWW DD-MMM')

Please see attached picture, this is the first column, "Day".

Is it possible to make it so that the dates are all in line, ie so that there is a larger space between Sunday and the date, than there would be between Wednesday and the date.

I did originally have this in two columns, but they need to be in one in order for my 'Total' label text to show fully.

I also don't want to shorten the days to 'WWW'.

Hopefully thank makes sense.

Thanks, Amy

Re: uneven spacing between text

atoz1158 — Wed, 31 Jul 2019 15:25:41 GMT

This will only work if you are using a FIXED width font.

=Left(Date(due_date, 'WWWW') & ' ',10) & Date(due_date, 'DD-MMM')

Regards

Adrian

topic Re: uneven spacing between text in QlikView

uneven spacing between text

Re: uneven spacing between text