Date format

[madhuqliklondon]

Hi,

I have a column 'IdDate' - and date format like '20170714'. I want to change it to qlikview date. I have tried giving Date(IdDate) at dimension level but it is coming with completely different date ex: 22/8/56786 . How can i change it to 14/07.2017?? is there a way?

Thanks in advance

[Anil_Babu_Samineni · Accepted solution]

May be this?

Date(Date#(IdDate,'YYYYMMDD'),'DD/MM.YYYY') as IdDate

OR

Date(Date#(IdDate,'YYYYMMDD'),'DD/MM/YYYY') as IdDate

[prma7799]

Try like this

=date(Date#(20170714,'YYYYMMDD'),'DD/MM/YYYY')

or

=date(Date#(IdDate,'YYYYMMDD'),'DD/MM/YYYY')

[madhuqliklondon]

Hi Anil,

Is this at script level or anywhere in the chart??

[Anil_Babu_Samineni]

This should work where ever you want, I meant to say in script or object level works

[prma7799]

You can create this in script level as well as chart level also

but when we are giving alise name it means script level and whiteout alising means chart level .

Script level

Date(Date#(IdDate,'YYYYMMDD'),'DD/MM/YYYY') as IdDate

Chart level

=date(Date#(IdDate,'YYYYMMDD'),'DD/MM/YYYY')

[shiveshsingh]

date(Date#(IdDate,'YYYYMMDD'),'DD/MM/YYYY')

[madhuqliklondon]

Thanks it is working, If I have to get Year, Month, Week and Day  is it better with master calendar ?? can I achieve it with this column name IdDate ??

[Anil_Babu_Samineni]

I don't think so whether master calendar need here. Because, you can use direct functions like Year(), Month(), Day(), Week() ....

Please close this thread, If you satisfy the answer where you looking

[madhuqliklondon]

Hi Anil,

can you an example for one of these Year(), Month(), Day(), Week().. I have tried it wasn't working.