Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More

Re: YTD QTD MTD sales

What number are you expecting to see for LMTD?

Re: YTD QTD MTD sales

May be this

if([SInvoice.Currency Code2]='INR',0,

Sum({<FinancialYear1=,MonthName1=, PostingNum={">=$(=Num(MonthStart(Max(PostingNum), -12)))<=$(=Num(AddMonths(Max(PostingNum), -12)))"}>} [SInvoice.Amount To Customer]))

to get 5,493,621

vijayptcs
Contributor II

Re: YTD QTD MTD sales

Thank you Legends tresesco‌ , stalwar1‌.