Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
simki
Contributor
Contributor

Use autoCalender.MonthsAgo after formatting a date

Hi guys,

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:

Max(Date(SUBMIT_DATE,'DD.MM.YYYY').autoCalendar.MonthsAgo)

 

I tried a lot but didnt get it running, so now i hope someone here can help me 🙂

 

Regards

Simon

Labels (3)
1 Solution

Accepted Solutions
Anil_Babu_Samineni

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')

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

2 Replies
Seyko
Partner
Partner

Hello,

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.

cordially.

Excuse my english, i'm french!
Anil_Babu_Samineni

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')

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post