topic Re: Regarding Chart Set Analasis in QlikView

Regarding Chart Set Analasis

Thu, 12 Jul 2012 12:33:11 GMT

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.

Re: Regarding Chart Set Analasis

Thu, 12 Jul 2012 12:42:11 GMT

use this

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

Re: Regarding Chart Set Analasis

Fri, 13 Jul 2012 05:29:55 GMT

Hi,

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

Re: Regarding Chart Set Analasis

Fri, 13 Jul 2012 05:30:07 GMT

Hi,

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

Re: Regarding Chart Set Analasis

Fri, 13 Jul 2012 05:49:52 GMT

Hi,

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