Bar Chart with multiple column names as dimensions
I have a sample data as below. I would like to show this information on chart with Range 1 to Range 9 on x-axis and all state names on y- axis. For example, with the below data for x-axis with value Range1 -> y- axis with value MI will have Data Point as 15.3 (1.5 + 2 + 11.8)
I'm new to qlikview and tried to achieve this using crosstable but couldn't achieve it. Please guide me on how to achieve this. Thank you in advance!