change date with actual date

[Anonymous]

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.

[olivierrobin]

hello

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

[shiveshsingh]

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

[Anonymous]

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

[Anonymous]

it is valid, how i can resolve that?

[olivierrobin]

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

[Anonymous]

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

I am not seeing that.

[olivierrobin]

look at the values of your X axis

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

[Anonymous]

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

[Anonymous]

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