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]

I would you ask you to buy Cookbook by Raff. This book is available in Amazon.com

For your question, this should like below

Load

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

Year(IdDate) as Year,

Month(IdDate) as Month,

Week(IdDate) as Week .....

[madhuqliklondon]

Hi Anil, I have tried that load already its not working . it is working for

Date(Date#(IdDate,'YYYYMMDD'),'DD/MM/YYYY') as IdDate, but not for Year() etc..

Pic: Year in multi box loaded as Year(IdDate) as Year

[Anil_Babu_Samineni]

Could be you must do some play around

Load *,

Year(IdDate) as Year,

Month(IdDate) as Month,

Week(IdDate) as Week ..... ;

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

[madhuqliklondon]

Ok..will try that. Thank you

[madhuqliklondon]

  Done by using below :

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

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

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

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

[Anil_Babu_Samineni]

Please close this thread

[madhuqliklondon]

Thanks all.