Solved: Re: Make date - Qlik Community

letileti · ‎2018-11-05

‌dear all,

am quite new to Qlik Sense.

Struggle deriving from field 'Fiscal year/period'

(in format 2015009 ) the YEAR and MONTH as date.

Both date and date # don't work.

Someone who can help with syntax?

Ivan_Bozov · ‎2018-11-05

In 2015009 you have an extra null that you do not need. Try:

Date(Date#(LEFT([Fiscal year/period],4)&RIGHT([Fiscal year/period],2), 'YYYYMM'), 'MM.YYYY') AS [Fiscal year/period]

vizmind.eu

View solution in original post

Ivan_Bozov · ‎2018-11-05

In 2015009 you have an extra null that you do not need. Try:

Date(Date#(LEFT([Fiscal year/period],4)&RIGHT([Fiscal year/period],2), 'YYYYMM'), 'MM.YYYY') AS [Fiscal year/period]

vizmind.eu

Anil_Babu_Samineni · ‎2018-11-06

What output you are expecting?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

letileti · ‎2018-11-07

Thanks a lot, Ivan!

Ivan_Bozov · ‎2018-11-07

No problem, glad it works.

vizmind.eu