Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

YTD QTD MTD sales

Hi All / stalwar1 ,

I need to calculate MTD QTD YTD for Total Amount (FCY) .

In the attachment there is two chart one is Exact and other is MTD QTD YTD Total Amount (FCY)

On the basis of Exact chart figure i want to calculate MTD....YTD but you can see the data is not matching with Exact chart.

Thanks.

12 Replies
Highlighted

What number are you expecting to see for LMTD?

Highlighted

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

Highlighted
Creator II
Creator II

Thank you Legends tresesco‌ , stalwar1‌.