topic Re: Date field formatting in QlikView

Date field formatting

Anonymous — Mon, 01 Oct 2012 11:04:34 GMT

Hi,

Is there a way to align all the records in this date field to the left.

Re: Date field formatting

sivarajs — Mon, 01 Oct 2012 11:10:21 GMT

Goto chart properties--> Presentation tab --> Change Alignment Numbers to left

Re: Date field formatting

whiteline — Mon, 01 Oct 2012 11:15:48 GMT

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.

Re: Date field formatting

Miguel_Angel_Baeyens — Mon, 01 Oct 2012 11:17:44 GMT

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

Re: Date field formatting

Anonymous — Mon, 01 Oct 2012 12:08:42 GMT

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

Re: Date field formatting

Miguel_Angel_Baeyens — Mon, 01 Oct 2012 12:12:53 GMT

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

Re: Date field formatting

Anonymous — Mon, 01 Oct 2012 12:17:29 GMT

Hi Miguel Angel Baeyens

I didnt change the field name in the chart all along, it's now aligned to the right as date format

Thanks so much

Re: Date field formatting

whiteline — Tue, 02 Oct 2012 05:06:35 GMT

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.