Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have a column with Dates in my Data, I want further column from it which shows Month , Qtr, years. I am using below code:
[DISP_DATE],
Week ([DISP_DATE]) as [DISP_Week],
Month([DISP_DATE]) as [DISP_Month],
Year([DISP_DATE]) as [DISP_Year],
'Q-' & Ceil(Month([DISP_DATE])/3) as [DISP_Quater],
I am able to compile code without an error , but when I try to use Week , Month , year column in my dashboard there is no value, can someone please help me in this regard, I am very new to Qlik and not sure what error I am making .
Also, DISP_DATE columns have values like 01-Sep-2016 , 03-Sep-2016 .... 02-Oct-2016
hi ,
can you attach the .qvf file and the excel file.
Thanks a ton Jagan, it's working now , can you please help me understanding why we added first Load statement for Date conversion? And can't we do it with one single Load.
Thx
Ankit
Thanks Sunny for correcting me, yes its MMM
Regards,
Ankit
Also is it - between them or /? Make changes to your environmental variable accordingly
SET DateFormat='DD-MMM-YYYY';
or
SET DateFormat='DD/MMM/YYYY';