Hello,
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!
State | Range1 | Range2 | Range3 | Range4 | Range5 | Range6 | Range7 | Range8 | Range9 |
MI | 1.5 | 4.58 | 2.8 | 5.6 | 5.5 | 4.58 | 2.8 | 5.6 | 5.6 |
MI | 2 | 27.8 | 2.6 | 10.8 | 2.6 | 27.8 | 2.6 | 10.8 | 10.8 |
OH | 3.5 | 9.0 | 11.5 | 35.0 | 2.6 | 9.0 | 11.5 | 35.0 | 35.0 |
MI | 11.8 | 0.5 | 16.9 | 25.5 | 12.5 | 0.5 | 16.9 | 25.5 | 25.5 |
KY | 32.6 | 19.9 | 45.6 | 11.0 | 15.0 | 19.9 | 45.6 | 11.0 | 11.0 |
KY | 5.7 | 16.1 | 1.8 | 5.6 | 11.8 | 16.1 | 1.8 | 5.6 | 5.6 |
AZ | 3.8 | 10.4 | 16.0 | 1.8 | 35.5 | 10.4 | 16.0 | 1.8 | 1.8 |