Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

RANGESUM in chart bar

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.

10 Replies
Not applicable
Author

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