topic Re: change date with actual date in QlikView

change date with actual date

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

Hello,

I would like to display the date of the day (2018) as put in my excel file.

At the date level in qlikview i dont DD / MM / YYYY but it still gives me the year = 1900 what to do please?

Thank for yours responses.

Re: change date with actual date

olivierrobin — Fri, 08 Jun 2018 12:01:52 GMT

hello

did you check the value of your column ? I think it doesn't contain a valid date

Re: change date with actual date

shiveshsingh — Fri, 08 Jun 2018 12:15:23 GMT

What is the format of your dimension(Date of day for 2018)? Are you changing the format in script?

Re: change date with actual date

Anonymous — Fri, 08 Jun 2018 13:58:19 GMT

DD/MM/YYYY even in the script, but it is not work.

Re: change date with actual date

Anonymous — Fri, 08 Jun 2018 13:59:08 GMT

it is valid, how i can resolve that?

Re: change date with actual date

olivierrobin — Fri, 08 Jun 2018 14:04:07 GMT

your X axis seems to contain values 1 , 2 , 3 which gives dates of yer 1900

so :

either this is their value

or the formula you use transform those values

Re: change date with actual date

Anonymous — Fri, 08 Jun 2018 14:17:29 GMT

Olivier Robin how remove those values 1, 2, 3?

I am not seeing that.

Re: change date with actual date

olivierrobin — Fri, 08 Jun 2018 14:19:54 GMT

look at the values of your X axis

01/01/1900 in date format is 1 in numeric and so on

Re: change date with actual date

Anonymous — Fri, 08 Jun 2018 14:20:22 GMT

and how to put a vertical line that indicates today's date

Re: change date with actual date

Anonymous — Fri, 08 Jun 2018 14:20:50 GMT

Shivesh Singh and how to put a vertical line that indicates today's date

Re: change date with actual date

kfoudhaily — Fri, 08 Jun 2018 14:23:02 GMT

https://qlikcommunity.qliktech.com/thread/219757

Re: change date with actual date

Anonymous — Fri, 08 Jun 2018 14:37:20 GMT

kh fou i say about x axe how i can format the date and display 2018 and no 1900?

Re: change date with actual date

Anonymous — Fri, 08 Jun 2018 14:45:37 GMT

I am changing at what level this is what is being done actually?

please!

Re: change date with actual date

olivierrobin — Fri, 08 Jun 2018 14:51:45 GMT

what is the field or the expression used in dimension tab ? (this is what we see on X axis)

-> it seems that is it not a date in the year 2018

if it is a partial date (say day month), you have to format it with date() function to obtain a valid date

to see the values, create a listbox with this expression and show it in numeric format.

Re: change date with actual date

kfoudhaily — Fri, 08 Jun 2018 14:54:49 GMT

yes, add days is the right expression

accualy, you don't have dates to convert their formats but you durations in days (91 day) from origin date.

if your origin date is 1/1/2018 + 91 days, the date should be 2/4/2018

to sumarize, in order to convert to dates you need to convert your duration to date starting form origin:

date(date(Origin_Date) +91, 'MM/DD/YYYY')

Re: change date with actual date

Anonymous — Fri, 08 Jun 2018 14:57:50 GMT

That is the expression and the fiels is phase

(Max([End Date])) - (min ( [Start Date]))&' '& 'Jours'

Re: change date with actual date

olivierrobin — Fri, 08 Jun 2018 15:01:09 GMT

if i Understand, this expression gives a number of day between 2 dates, and not a date

this is why you have 1 , 2 , .... and so on as value

don't you have a column with a date ti use as X axis (Start date maybe ?)

Re: change date with actual date

kfoudhaily — Fri, 08 Jun 2018 15:05:30 GMT

calculating the maximum duration?

try,

date(date([Start Date]) +(Max([End Date])) - (min ( [Start Date])), 'MM/DD/YYYY')

assuming that [Start Date] is the reference date, but this should be depending on the context

please provide a preview of your table and what are you calculating.

regards,

Re: change date with actual date

Anonymous — Fri, 08 Jun 2018 15:08:32 GMT

That is excel file, it has start date and end date ( 2018) but it is not display in qlikview

Re: change date with actual date

olivierrobin — Fri, 08 Jun 2018 15:10:49 GMT

so, if you want to display the bar beginning at the start date, why dion't you use that column on your axis ?