Discussion board where members can learn more about Qlik Sense App Development and Usage.
i have a data set where the "SUBMIT_DATE" is formatted like this: DD.MM.YYYY
Now i need to format it correct to use it with the .autoCalender.MonthsAgo function to get the values with the highest months ago. This is what i need to get working:
I tried a lot but didnt get it running, so now i hope someone here can help me 🙂
That is field hence you can't use. To achieve format perhaps this?
Date(Date#(Max(Date(SUBMIT_DATE,'DD.MM.YYYY')), 'DD.MM.YYYY'), 'Wanted Format Here')
View solution in original post
The autocalendar table is supposed to be auto-generate. Following this link to go to this online help. You can obtain this table by your data manager (after you applicated the synchonization). Normally, the *.MonthsAgo field is created.