Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Champion III
Champion III

Look here for more information:

YTQ, QTD, MTD and WTD