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.

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

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



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



Bar chart:



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