Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.