topic Re: Rangeavg in reverse in QlikView

Rangeavg in reverse

Anonymous — Wed, 12 Jul 2017 05:41:45 GMT

Hi Guys,

i have input table like

tab:

load * inline [

ID,Sale

1,100

2,200

3,500

4,600 ]

i need out put in pivot table like

ID 4,3,2,1

Rangeavg 350,267,150,100

Regards,

Mahesh

tresB — Wed, 12 Jul 2017 06:04:37 GMT

Try like:

antoniotiman — Wed, 12 Jul 2017 06:06:11 GMT

Hi Mahesh,

try this Expression

RangeAvg(Bottom(Sum(Sale),1,NoOfRows()-RowNo()+1))

Regards,

Antonio

Anil_Babu_Samineni — Wed, 12 Jul 2017 06:07:36 GMT

May be this?

RangeAvg(Below(Avg(Sale),0),Above(Sale,1,RowNo(Total)))

And if pivot table, Amy be this

RangeAvg(After(Sale,0,Count(TOTAL DISTINCT ID)))

Anil_Babu_Samineni — Wed, 12 Jul 2017 06:17:29 GMT

This may work Column level not the Row Level like Transpose for ID ??

antoniotiman — Wed, 12 Jul 2017 06:33:25 GMT

RangeAvg(Last(Sum(Sale),1,NoOfColumns()-ColumnNo()+1))

tresB — Wed, 12 Jul 2017 06:39:01 GMT

And a more efficient expression could be : RangeAvg(After(Sale,0,NoOfColumns()))