Discussion Board for collaboration on QlikView Scripting.
Actually, I need to tranform a string into date for example:
Until now I only isolated 2012_Q"2" and try to make appear every informations that quarter can show but that way didn't work. Then, do you have a idea to make this string in data?
Go to Solution.
The following script gives
Date(MakeDate(Left(YYYY_QN,4),(Right(YYYY_QN,1)-1)*3+1,1)) as QStart;
LOAD * Inline [
Perhaps like this: makedate(left(YearQuarter,4),right(YearQuarter,1)*3-2)