Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Question on bar chart: expression formula

Hello,

I have an excel file with one column showing the average revenue per month as follows:

That means that in January the revenue was 1295.

In February the 2059 is the average revenue generated in January+February

In March the 2219 is the average revenue generated in January+February+March

In April the 2380 is the average revenue generated in January+February+March+April

.....

I want to create a bar chart showing the revenue per each month, not the average revenue accumulated. That would mean the following:

January = 1295

February = 2059 * 2 (months) - sum (revenue from January)

March = 2219 * 3 (months) - sum (revenue from January+February)

April = 2380 * 4 (months) - sum (revenue from January+February+March)

...

Following these formulas the revenue per month would be as follows, and this is the data I want to show in a bar graph:

And here the question: do you know what I should write in the expression formula to get these figures ?

Attached the xls file

Thanks,

dani

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Check attached qvw.

View solution in original post

2 Replies
Highlighted
MVP
MVP

Check attached qvw.

View solution in original post

Highlighted
Creator III
Creator III

Great Tresesco. This is just what I was looking for !!!