Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

sri
New Contributor

Bar Chart with multiple column names as dimensions

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

Labels (1)