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: 
qlikviewforum
Creator II
Creator II

Average

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!

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

View solution in original post

1 Reply
swuehl
MVP
MVP

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