Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: Regarding Chart Set Analasis

use this

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

Not applicable

Re: Regarding Chart Set Analasis

Hi,

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

Not applicable

Re: Regarding Chart Set Analasis

Hi,

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

Not applicable

Re: Regarding Chart Set Analasis

Hi,

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

Community Browser