Difference in No.of Weeks?

devarasu07 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have used below formula in expression to get the article No.of Weeks difference based on user selected year and week from list box,

=((vCurrYear-(min(TOTAL <ArticleNo> {<Year={'*'},Week= {"*"},Type={'Sales'},StoreName=>} Year(Date)))) *53)+

(vCurrentWeek-min(TOTAL <ArticleNo> {<Year={'*'},Week= {"*"},Type={'Sales'},StoreName=>} Week(AddYears(Date,(year(Date)-vCurrYear)))))

above week difference formula is working fine for current selected year but it's not working for historical year? do you have any suggestion? thanks

Note:

vCurrYear & vCurrentWeek --> created variable for user selected year & Week

Best Regards,

Dev

topic Difference in No.of Weeks? in QlikView