Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a csv I'm loading with a column titled 'year-month', which contains dates formatted yyyy-mm. Qlik isn't recognising it as a date so I can't use calendar functions:
I can't figure out what I need to do to have Qlik recognise this as a date. Am I best off just formatting the date with days (with date being first of the month for all records) or is there another month/year syntax I can use that will be recognised?
How you are seeing in CSV file? Does CSV holds in Date format? If so, We can use Date() around the field. If there is any Date format issue you can define as
Load Date(Date#(year_month, 'YYYY-MM')) as year_month From ...;
How you are seeing in CSV file? Does CSV holds in Date format? If so, We can use Date() around the field. If there is any Date format issue you can define as
Load Date(Date#(year_month, 'YYYY-MM')) as year_month From ...;
Used your formula in the data manager to create a calculated column - does the trick!
Thanks!