Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
ngangrad
Partner
Partner

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.

 

 

Labels (1)
0 Replies