Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this?
Date(Date#(IdDate,'YYYYMMDD'),'DD/MM.YYYY') as IdDate
OR
Date(Date#(IdDate,'YYYYMMDD'),'DD/MM/YYYY') as IdDate
May be this?
Date(Date#(IdDate,'YYYYMMDD'),'DD/MM.YYYY') as IdDate
OR
Date(Date#(IdDate,'YYYYMMDD'),'DD/MM/YYYY') as IdDate
Try like this
=date(Date#(20170714,'YYYYMMDD'),'DD/MM/YYYY')
or
=date(Date#(IdDate,'YYYYMMDD'),'DD/MM/YYYY')
Hi Anil,
Is this at script level or anywhere in the chart??
This should work where ever you want, I meant to say in script or object level works
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')
date(Date#(IdDate,'YYYYMMDD'),'DD/MM/YYYY')
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 ??
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
Hi Anil,
can you an example for one of these Year(), Month(), Day(), Week().. I have tried it wasn't working.