Formula for month-to-date; quarter-to-date, etc.

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I am a new user to Qlikview and I am trying to set up so that the data for the current month is phased based on the percentage completed. For example, if I have $100 as the month total, on the 15th day, it will be at $50. I am currently using the formula below, which works when looking at the current month, but if you look at a prior month, it is also phasing that month. I am guessing something could possibly be done with a if statement? Any help would be greatly appreciated.

[code]=((Sum({<Version={Forecasted Sales}>}[Net Sales]))*(Num(Day(Today())/Day(MonthEnd(Today())), '##.##%')))/1000000 [/code]

Re: Formula for month-to-date; quarter-to-date, etc.

vishsaggi — Fri, 17 Mar 2017 19:38:48 GMT

Look here for more information:

YTQ, QTD, MTD and WTD

topic Formula for month-to-date; quarter-to-date, etc. in QlikView

Formula for month-to-date; quarter-to-date, etc.

Re: Formula for month-to-date; quarter-to-date, etc.