Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ValeriaBonini
Partner - Creator
Partner - Creator

Date conversions

Hi, i'm new to Qlik sense, can someone explain to me this partof code, expecially the bold one?

Let twoYearsAgo= AddYears(Today(),-2); 
Let quarters= AddMonths(vvar,3); 
Let viter = 0;

do while twoYearsAgo < quarters

Let vmon = Year(twoYearsAgo) * 100 + Month(twoYearsAgo);

IF viter = 0

Load...

Else 

Load...

endif

Let viter = viter + 1;
Let twoYearsAgo= AddMonths(twoYearsAgo);

loop

 

Labels (5)
1 Reply
Or
MVP
MVP

Someone is converting the date into a format such as 202208 (August 2022). Why? Can't say, it's not in the part of the code that was posted.