Discussion board where members can learn more about Qlik Sense App Development and Usage.
I'm trying to concatenate a row containing the quarter (Q1, Q2, Q3, Q4) and year (1990,1991,...) and turn it into a date. I tried using the following code:
Date(Makedate("Year"), 'YYYY') as YEAR,
Date(Makedate("Year",right(Qrt,2)), 'QQYYYY') as QuarterYEAR,
It's not working as intended. What am I doing wrong?
May be this
"Year" as YEAR,
Date(MakeDate("Year", (Right(Qrt, 1) * 3)), 'MMYYYY') as MonthYEAR,
It worked! It is possible to get the add a "/"? Currently, format is '032013'.
Date(MakeDate("Year", (Right(Qrt, 1) * 3)), 'MM/YYYY') as MonthYEAR,