Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
nishika
Partner - Contributor III
Partner - Contributor III

rangesum expression to split into 6 measure

I have created bar chart having two dimension month and Territory, and One measure

#Rangesum(Above(Sum({<#CalendarYear=-{'$(=$(#vCurrYear))'}, @CalendarMonthName=>}[ACT@AR]),0,RowNo()))*#vcurrrate

but i need to add one more measure for "Open Order" to Bar chart but that is not possible in bar chart

 sum({<#CalendarYear={'$(=$(#vCurrYear))'}>}[ACT@AR])*#vcurrrate 

 

so i want to convert bar chart to combo chart where we can have one dimension and 15 measures.

 

 

Bar chart:

ngangrad_0-1610354754305.png

 

Can anyone help how to convert range sum expression for 6 territory?

Territory are Mexico/CAC, Northeast, Southeast, zAmericas Other, South America, West.

 

 

0 Replies