Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

thorsten_edler
New Contributor II

Display of monthly balance in chart.

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

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Display of monthly balance in chart.

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

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

Hope this helps,

Jason

View solution in original post

2 Replies
Highlighted
Partner
Partner

Re: Display of monthly balance in chart.

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

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

Hope this helps,

Jason

View solution in original post

Highlighted
thorsten_edler
New Contributor II

Re: Display of monthly balance in chart.

My dear friend,

this is perfect!

🙂

Thorsten