Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is there a way to align all the records in this date field to the left.
Hi,
One solution is as Sivaraj suggests above. However, if QlikView detects a number as a date, it aligns to the right (according to its numeric value). If it understands the value as a string instead, then it will be aligned to the left, by default. If you operate those dates, it's likely you will not get correct results, as you have both numeric and literal values.
The best way to do it is to change the LOAD statement in your script and set all date fields to have the same format, using the Date() and Date#() functions.
Hope that makes sense.
Miguel
Goto chart properties--> Presentation tab --> Change Alignment Numbers to left
Hi.
It seems that your [Expiry date] field contains number and string values.
By default strings are aligned to the left while numbers to the right.
I suggest to deside witch type of values you need and convert them correspondingly, instead of just changing the view alignment.
Hi,
One solution is as Sivaraj suggests above. However, if QlikView detects a number as a date, it aligns to the right (according to its numeric value). If it understands the value as a string instead, then it will be aligned to the left, by default. If you operate those dates, it's likely you will not get correct results, as you have both numeric and literal values.
The best way to do it is to change the LOAD statement in your script and set all date fields to have the same format, using the Date() and Date#() functions.
Hope that makes sense.
Miguel
Hi guys,
@Sivaraj Seeman I just tried that and that didn't work also
@whiteline I simply want to use the numbers as date however i have already tried these date functions @Miguel Angel Baeyens suggested and yet no luck
Could it be the way the data was captured, and is there any other date function(s) i can try? Thanks
Hi,
Sure there is a way to pull data in the correct way, but not knowing how the values are in the source, it's difficult to set an example. Using either Date() or Date#() will do, as it does in most cases. Anyway, post a couple of sample lines here so we can help further.
Miguel
I didnt change the field name in the chart all along, it's now aligned to the right as date format
Thanks so much
Hi.
It's strange that you have both numbers and strings. It seems that you LOAD this field into more than one table. So in one case you've converted them properly unlike the others.
From the other hand the source contains dates in different formats and you didn't use alt() function to handle all of them.
You could post all LOAD statements where [Expiry date] is contained.
And an example of your source data would also be helpful.