Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.