Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Champion III
Champion III

Look here for more information:

YTQ, QTD, MTD and WTD