Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I am working on an excel sheet with different columns for a date , ie Year, month, day.
LOAD Year,
Month,
Day,
Hour,
Celsius,
Rain_mm,
Sun_Minutes,
MakeDate (Day&Month&Year) as Date
i have been trying using MAKEDATE to generate the date but in returns...i have this...01.01.112012, 01.01.122012, etc...
what i have done wrong ?
thanks
JP
Hi Jean,
try like this:
Date(MakeDate(Year, Month,Day),' Date Fromt which is ur req') AS Date.
Ramya.
Hi Ramya,
just tried and no result ;(
Have you seen my example?
Please Post your Data that is giving you the wrong results so that we can help you
Hello i have 29938 lines of datas as stated above stored in an excel sheet
LOAD Year,
Month,
Day,
MakeTime(Hour) as H,
Celsius,
Rain_mm,
Sun_Minutes,
Date(MakeDate (Year,Month,Day),'DD.MM.YYYY') as Date
FROM
(
and this is my script, currently returning 1 line for the date which is 01.01.2012....and i am totally stuck and quite new on qlik
Hi,
I see there is scroll bar .
Either increase height of List box of Scroll it.
Regards
Hello,
Your box should be extended. See the scroll bar on the side.
.... i think that i need a coffee the final word is THANKS and the correct Script for MAKEDATE is
Date(MakeDate (Year,Month,Day),'DD.MM.YYYY') as Date
Please close this thread