Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

jameswills
New 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

Re: Expression Help Please

May be this

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

View solution in original post

1 Reply

Re: Expression Help Please

May be this

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

View solution in original post