Hi, I have used SQL to generate a table that I have imported into Qlik Sense. One variable auditdate [(convert(date,AnswerDate)) as AuditDate ] within Qlik is not automatically producing a hierarchy of dates.
How can I get Qlik to do this automatically or how can I create a year month hierarchy?
