topic need MTD calculation help in QlikView

need MTD calculation help

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am using the below set analysis for my MTD calculation at straight table:

[Order Date]={"$(='>=' & Date(MonthStart(Max([Order Date])), 'MM/DD/YYYY') & '<=' & Date(Max([Order Date]), 'MM/DD/YYYY'))"}>}Sales)

but it gives me wrong result and in the below screenshots you can see that: Ideally it should show all the order date in the table, but it only show the last year's date in the 'Order Date' column.Also the MTD value should be start date of the Order Date's month to the corresponding Order date, but the value in MTD column is wrong here.

Also I am attaching my demo QVW for reference.

Re: need MTD calculation help

sunny_talwar — Tue, 02 May 2017 11:14:09 GMT

May be this

Sum({$<[Order Date]={">=$(=Date(MonthStart(Max([Order Date]))))<=$(=Max([Order Date]))"}>}[Sales])

Re: need MTD calculation help

rahulpawarb — Tue, 02 May 2017 11:17:54 GMT

Hello Sandip,

Please refer below link:

Date Level Analysis - WTD, MTD, QTD & YTD (Current Year & Previous Year)

Regards!

Rahul