Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Regarding Chart Set Analasis

Hi,

I am having Apr and May month wise MTD and YTD Actuals in chart. The Set analasis for YTD is "=Sum({<Year ={$(V_Max_Actual)},BudgetType_FCBUD=>}Amount/num(Denominator))".  Currently Data is comming for Selected Monthwise. I want display data like suppose user selected Apr and May., in may month YTD actuals i want add Apr month YTD data also. In same way if suppose user selected APR,May,June., in may month i want show apr + may and june month may+june YTD Actuals. For ref., see attachment. Kindly suggest set analasis for calculating YTD Actuals for previous month or some other script for YTD Actuals.

4 Replies
Not applicable
Author

use this

Sum({<Year ={$(V_Max_Actual)},BudgetType_FCBUD=,Month=>}Amount/num(Denominator)

Not applicable
Author

Hi,

Thanks for u r answer.  While i am adding Month my YTD Actuals is coming all 0.00.

Not applicable
Author

Hi,

Thanks for u r answer.  While i am adding Month my YTD Actuals is coming all 0.00.

Not applicable
Author

Hi,

Thanks for u r answer.  While i am adding Month my YTD Actuals is coming all 0.00.