Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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