Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

May be this

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

View solution in original post

1 Reply

May be this

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

View solution in original post