Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jameswills
Contributor II
Contributor II

Expression Help Please

I'm after some hep with the syntax for an expression in a chart please?

I have three dimensions:

Period, Account and GLActual

I'd like to construct a combo chart with two expressions:

Sum(GLActual) as a column, which I can do no problem 🙂

I would then like a flat line which shows 80% of the average of the sum of selcted periods, please see examples below where Series 1 is the basic actual sum and series 2 the 80% average of the cumulatie:

example.PNG

Any help would be greatly appreciated.

1 Solution

Accepted Solutions
sunny_talwar

May be this

Avg(TOTAL Aggr(Sum(GLActual), Period)) * 0.80

View solution in original post

1 Reply
sunny_talwar

May be this

Avg(TOTAL Aggr(Sum(GLActual), Period)) * 0.80