topic Re: Date format in QlikView

Date format

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

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

Re: Date format

Anil_Babu_Samineni — Tue, 18 Jul 2017 10:48:20 GMT

May be this?

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

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

Re: Date format

prma7799 — Tue, 18 Jul 2017 10:52:37 GMT

Try like this

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

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

Re: Date format

madhuqliklondon — Tue, 18 Jul 2017 11:11:47 GMT

Hi Anil,

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

Re: Date format

Anil_Babu_Samineni — Tue, 18 Jul 2017 11:14:37 GMT

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

Re: Date format

prma7799 — Tue, 18 Jul 2017 11:17:08 GMT

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')

Re: Date format

shiveshsingh — Tue, 18 Jul 2017 11:23:09 GMT

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

Re: Date format

madhuqliklondon — Tue, 18 Jul 2017 12:52:11 GMT

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 ??

Re: Date format

Anil_Babu_Samineni — Tue, 18 Jul 2017 13:02:06 GMT

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

Re: Date format

madhuqliklondon — Tue, 18 Jul 2017 13:08:29 GMT

Hi Anil,

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

Re: Date format

Anil_Babu_Samineni — Tue, 18 Jul 2017 13:14:05 GMT

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 .....

Re: Date format

madhuqliklondon — Tue, 18 Jul 2017 13:41:13 GMT

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

Re: Date format

Anil_Babu_Samineni — Tue, 18 Jul 2017 13:44:13 GMT

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;

Re: Date format

madhuqliklondon — Tue, 18 Jul 2017 13:45:20 GMT

Ok..will try that. Thank you

Re: Date format

madhuqliklondon — Tue, 18 Jul 2017 14:08:51 GMT

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,

Re: Date format

Anil_Babu_Samineni — Tue, 18 Jul 2017 14:16:34 GMT

Please close this thread

Re: Date format

madhuqliklondon — Tue, 18 Jul 2017 14:49:28 GMT

Thanks all.