Average

[qlikviewforum]

I have below expression in one of the chart as the first expression.

SUM({<Period = {'>$(=date($(vMaxDate)-$(vSelectDate))) <=$(=date($(vMaxDate)))'}>} Sales)

/

SUM({<Period = {'>$(=date($(vMaxDate)-$(vSelectDate))) <=$(=date($(vMaxDate)))'}>} Market)

I want to use the below rangeavg on top of the above expression as the 2nd expression of the chart.

rangeavg(Above(sum(<<ABOVE EXPRESSION>>), 0, 3))

As we need to use the expression on rangeavg it is little dificult to achieve this. Can someone helpme to achieve the same? It is little urgent!

[swuehl · Accepted solution]

I think you probably mean

rangeavg(Above( <<ABOVE EXPRESSION>> , 0, 3))

i.e.

rangeavg(Above(

SUM({<Period = {'>$(=date($(vMaxDate)-$(vSelectDate))) <=$(=date($(vMaxDate)))'}>} Sales)

/

SUM({<Period = {'>$(=date($(vMaxDate)-$(vSelectDate))) <=$(=date($(vMaxDate)))'}>} Market)

, 0, 3))