how can I do this

ali_hijazi — Thu, 12 Jan 2012 13:45:18 GMT

Hello

I got a variable or an expression that calculates the balance amount for a category of accounts up to a selected month as follows:

sum({<DBCR={'D'},Cat_3_Name=Cat_3_Name-{"Cash and Banks","Banks' overdrafts and short term loans"},Year ={$(=max(Year))},MonthNum ={"<=$(=max(MonthNum)) "},Month=>} MontLC2 * Multiplier)

sum({<DBCR={'C'},Cat_3_Name=Cat_3_Name-{"Cash and Banks","Banks' overdrafts and short term loans"},Year ={$(=max(Year))},MonthNum ={"<=$(=max(MonthNum)) "},Month=>} MontLC2 * Multiplier)

Now I want to show the variation of the value of the above expression per month on a line chart;

I put the above expression in this chart whose Dimension is Month from the calendar

However this expression doesn't return the desired results

topic how can I do this in QlikView

how can I do this