Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Highlighted
sagarpawar
Not applicable

YTD Calculation by month

HI ,

Can someone help me on below scenario.

We have Budget , Forecast1 and forecast2 by month and also we have Budget_Rate, Forecast1_Rate and Forecast2_Rate by month.

There is calculation for month Jan as

=(Jan Forecast2/Jan Forecast2_Rate) will consider as Jan_EUR

For Feb month we have calculation

=(Jan_Eur+((Feb Forecast2 - Jan Forecast2 )/Feb Forecast2_Rate)) as Feb_EUR

For Mar month 

= (Feb_EUR++((Forecast2 of Mar month - Forecast2 of Feb Month)/Mar Forecast2_Rate))  as Mar_Eur.

Next every month we have same calculations.

Can you please help me to calculate Jan_Eur,Feb_Eur,Mar_Eur,...........Dec_Eur.

We have to perform this in backend and the will do Sum of Jan_Eur,Feb_Eur, etc..  in frontend.

 

Thanks,

Sagar

SGP
2 Replies
sunny_talwar
Not applicable

Re: YTD Calculation by month

Would you be able to provide some sample data and the output expected from it?

sagarpawar
Not applicable

Re: YTD Calculation by month

Hi Sunny,

PFA: Sample data for scenario.

Thanks,

Sagar

 

SGP