Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm trying to format my dates from the various data sources I'm getting my data from. One data source represents the date by two separate columns (Year and Month). I would like to combine these two columns into a single one, but also change the month format.
For instance,
Year = YYYY
Month = M01
Date = JanYYYY
I hope someone could help me with this.
Thank you,
Jessica
Hi Jessica,
your solution will include two parts:
1. Build a proper date field
2. Format the date field in the required way.
In order to build the proper date field, use the MakeDate function and only use the last 2 characters of the Month:
MakeDate(Year, Right(Month, 2))
Then enclose the same in the formatting function Date():
Date(MakeDate(Year, Right(Month, 2)), 'MMMYYYY')
That will do the job.
cheers,
Oleg Troyansky
Learn advanced QlikView and Qlik Sense techniques in my book QlikView Your Business