Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

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

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]

1 Reply
vishsaggi
Esteemed Contributor III

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

Look here for more information:

YTQ, QTD, MTD and WTD