Average

qlikviewforum — Mon, 29 Dec 2014 17:16:19 GMT

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!

Re: How to use rangeavg on top of the expression.

swuehl — Mon, 29 Dec 2014 17:21:33 GMT

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))