topic RangeAvg is not working in QlikView

RangeAvg is not working

Thu, 04 Aug 2016 15:01:04 GMT

What is wrong in this formula? I couldnt get the average

RangeAvg(Above(sum([$(vCurrency) Satış]) / (sum([KG Satış]))*1000,0, 12))

Re: RangeAvg is not working

vishsaggi — Thu, 04 Aug 2016 15:19:58 GMT

Can you share a sample app to look into? And what is Satis here, is that a field name ?

Re: RangeAvg is not working

sunny_talwar — Thu, 04 Aug 2016 15:22:24 GMT

What are you getting and what do you expect to get?

Re: RangeAvg is not working

Fri, 05 Aug 2016 08:22:13 GMT

Hi,

Green numbers must be same with the green bar chart.

And gray number must be same as gray bar chart.

Formula for bar chart is; RangeAvg(Above(sum([$(vCurrency) Satış]) / (sum([KG Satış]))*1000,0, 12))

Formula for table is; rangesum( before( sum([$(vCurrency) Satış]),0,NoOfColumns(TOTAL) ) ) / rangesum( before( sum([KG Satış]),0,NoOfColumns(TOTAL) ) )/1000

Nisan Mayıs Haziran

Re: RangeAvg is not working

sunny_talwar — Fri, 05 Aug 2016 09:34:32 GMT

The formula are not exact match of each other. There are a lot of differences between the two formulas. I can propose something, but not 100% certain it will work... try this in the bar chart

RangeSum(Above(Sum([$(vCurrency) Satış]), 0, NoOfRows(TOTAL)))/RangeSum(Above(Sum([KG Satış]), 0, NoOfRows(TOTAL)))/1000

RangeSum(Above(Sum([$(vCurrency) Satış]), 0, RowNo(TOTAL)))/RangeSum(Above(Sum([KG Satış]), 0, RowNo(TOTAL)))/1000

If they do not work, would you be able to provide a sample to look at what is going on?

Best,

Sunny

Re: RangeAvg is not working

Fri, 05 Aug 2016 10:14:29 GMT

I tried but it doesnt work.

I couldnt provide a sample bc its a company document, all .qvw's are classified info

Re: RangeAvg is not working

sunny_talwar — Fri, 05 Aug 2016 11:18:08 GMT

Have you checked this link:

Preparing examples for Upload - Reduction and Data Scrambling

Re: RangeAvg is not working

Tue, 09 Aug 2016 06:33:34 GMT

Hi guys,

I forgot uncheck the accumulate option, thats why i couldnt get the average.

Thanks for replies.