Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

uneven spacing between text

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

1 Reply
Creator II
Creator II

Hi

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