Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I would like to compare sales N against sales N-1 day per day

My formula for one year

I take into account some restrictions

-sum({<LEDGERACCOUNT={700000,700005,708000,700110},TYPE = {1}>} ACCOUNTINGCURRENCYAMOUNT)

i don't know where and how should i write down the condition previous year at the same day:

-sum({<LEDGERACCOUNT={700000,700005,708000,700110},TYPE = {1}, ACCOUNTINGDATE={"<=$(=date(ACCOUNTINGDATE)-365)"}>} ACCOUNTINGCURRENCYAMOUNT)

Thanks for helping

0 Replies