topic Re: RANGESUM in chart bar in QlikView

RANGESUM in chart bar

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a problem in bar chart while i was trying to write rangesum() function.

There are screenshots of table and bar chart.

In table, formula is: "küm.ciro"/"küm.ton"

küm.ciro --> rangesum( before( sum([$(vCurrency) Satış]),0,NoOfColumns(TOTAL) ) )

küm.ton ---> rangesum( before( sum([KG Satış]),0,NoOfColumns(TOTAL) ) )/1000

In bar chart, formula is: (sum([$(vCurrency) Satış]) / sum([KG Satış]))*1000

This means that -for example in second column.-

table chart shows us (FirstValue + SecondValue) / 2 = (1.877,xx + 1.904,xx) / 2 = 1.891,xx

bar chart shows us only SecondValue = 1.904

I have to do this in bar chart but dont know how to do.

Thank you for your help.

Re: RANGESUM in chart bar

sunny_talwar — Thu, 14 Jul 2016 12:31:02 GMT

Is this in a pivot table? I think you will have to provide more details here and a sample will be really helpful

Re: RANGESUM in chart bar

Thu, 14 Jul 2016 12:42:56 GMT

Yes, it is in a pivot table.

I cant provide a sample cause this sheet works for my business -classified info-

Re: RANGESUM in chart bar

Gysbert_Wassenaar — Thu, 14 Jul 2016 12:43:15 GMT

Perhaps like this: rangesum(above( (sum([$(vCurrency) Satış]) / sum([KG Satış]))*1000 ,0, rowno()))

Re: RANGESUM in chart bar

jonathandienst — Thu, 14 Jul 2016 12:45:09 GMT

Try using Above() instead of Before() for the chart. Before is only meaningful in a pivot table.

Re: RANGESUM in chart bar

sunny_talwar — Thu, 14 Jul 2016 12:45:28 GMT

Gysbert do we need RangeAvg() instead of RangeSum?

and also Before() and ColumnNo() as this seems to look like a pivot table. I might be wrong, but I am not really sure how the table is laid out

Re: RANGESUM in chart bar

jonathandienst — Thu, 14 Jul 2016 12:56:34 GMT

I agree that you should use RangeAvg() rather than Rangesum, but I think Gysbert is correct using Above() and Rowno() for the chart

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

Re: RANGESUM in chart bar

sunny_talwar — Thu, 14 Jul 2016 13:00:09 GMT

But are we not doing this in this direction ->

Unless this is a horizontal straight table, I feel we should use Before. What do you guys think?

Re: RANGESUM in chart bar

sunny_talwar — Thu, 14 Jul 2016 13:30:37 GMT

Have you given this a shot?

=RangeAvg(Before((Sum([$(vCurrency) Satış]) / Sum([KG Satış]))*1000 , 0, ColumnNo()))

Re: RANGESUM in chart bar

Thu, 14 Jul 2016 13:35:55 GMT

I used RangeAvg and Above but bar chart and pivot table doesnt match.

Re: RANGESUM in chart bar

Thu, 14 Jul 2016 14:27:44 GMT

I used RangeAvg and Above but bar chart and pivot table doesnt match.