# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for
Did you mean:
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
Luminary Alumni

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

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

Hope this helps,

Jason

2 Replies
Luminary Alumni

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

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

Hope this helps,

Jason

Contributor II
Author

My dear friend,

this is perfect!

🙂

Thorsten

Community Browser