Display of monthly balance in chart.

thorsten_edler — Thu, 16 Aug 2012 16:59:02 GMT

Hello.

I have a chart with monthly sum of sales over a period of a year and would like to show the balance between each month in the same chart, but am having problems.

I'm using this set analysis expressions

Tables : - year: (2008,2009,2010,2011)

- month: Numbers between 1 and 12

- balance : net sum of monthly sales

Dimension : month

expression 1 : = sum( {$<year={'$(=year)'},Monat={'$(=month)'}>} balance )

expression 2 : = sum( {$<year={'$(=year)'},Monat={'$(=month - 1)'}>} balance )

expression 3 : = Column(1) - Column(2)

The problem is that its just working when I select one month.

But I need to display it for every month in the chart as a whole.

regards

Thorsten Edler

Re: Display of monthly balance in chart.

Jason_Michaelides — Thu, 16 Aug 2012 17:35:37 GMT

If Sum(Balance) is your first expression then try this as your second:

Sum(Balance)-Above(Sum(Balance))

Hope this helps,

Jason

Re: Display of monthly balance in chart.

thorsten_edler — Fri, 17 Aug 2012 05:21:48 GMT

My dear friend,

this is perfect!

🙂

Thorsten

topic Re: Display of monthly balance in chart. in QlikView

Display of monthly balance in chart.

Re: Display of monthly balance in chart.

Re: Display of monthly balance in chart.