topic Bar Chart with multiple column names as dimensions in QlikView https://community.qlik.com/t5/QlikView/Bar-Chart-with-multiple-column-names-as-dimensions/m-p/1541212#M743420 <P>Hello,</P><P>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.&nbsp; &nbsp;For example, with the below data for x-axis with value Range1 -&gt; y- axis with value MI will have Data Point as 15.3 (1.5 + 2 + 11.8)&nbsp;</P><P>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.&nbsp; Thank you in advance!</P><TABLE><TBODY><TR><TD><P>State</P></TD><TD><P>Range1</P></TD><TD><P>Range2</P></TD><TD><P>Range3</P></TD><TD><P>Range4</P></TD><TD><P>Range5</P></TD><TD><P>Range6</P></TD><TD><P>Range7</P></TD><TD><P>Range8</P></TD><TD><P>Range9</P></TD></TR><TR><TD><P>MI</P></TD><TD><P>1.5</P></TD><TD><P>4.58</P></TD><TD><P>2.8</P></TD><TD><P>5.6</P></TD><TD><P>5.5</P></TD><TD><P>4.58</P></TD><TD><P>2.8</P></TD><TD><P>5.6</P></TD><TD><P>5.6</P></TD></TR><TR><TD><P>MI</P></TD><TD><P>2</P></TD><TD><P>27.8</P></TD><TD><P>2.6</P></TD><TD><P>10.8</P></TD><TD><P>2.6</P></TD><TD><P>27.8</P></TD><TD><P>2.6</P></TD><TD><P>10.8</P></TD><TD><P>10.8</P></TD></TR><TR><TD><P>OH</P></TD><TD><P>3.5</P></TD><TD><P>9.0</P></TD><TD><P>11.5</P></TD><TD><P>35.0</P></TD><TD><P>2.6</P></TD><TD><P>9.0</P></TD><TD><P>11.5</P></TD><TD><P>35.0</P></TD><TD><P>35.0</P></TD></TR><TR><TD><P>MI</P></TD><TD><P>11.8</P></TD><TD><P>0.5</P></TD><TD><P>16.9</P></TD><TD><P>25.5</P></TD><TD><P>12.5</P></TD><TD><P>0.5</P></TD><TD><P>16.9</P></TD><TD><P>25.5</P></TD><TD><P>25.5</P></TD></TR><TR><TD><P>KY</P></TD><TD><P>32.6</P></TD><TD><P>19.9</P></TD><TD><P>45.6</P></TD><TD><P>11.0</P></TD><TD><P>15.0</P></TD><TD><P>19.9</P></TD><TD><P>45.6</P></TD><TD><P>11.0</P></TD><TD><P>11.0</P></TD></TR><TR><TD><P>KY</P></TD><TD><P>5.7</P></TD><TD><P>16.1</P></TD><TD><P>1.8</P></TD><TD><P>5.6</P></TD><TD><P>11.8</P></TD><TD><P>16.1</P></TD><TD><P>1.8</P></TD><TD><P>5.6</P></TD><TD><P>5.6</P></TD></TR><TR><TD><P>AZ</P></TD><TD><P>3.8</P></TD><TD><P>10.4</P></TD><TD><P>16.0</P></TD><TD><P>1.8</P></TD><TD><P>35.5</P></TD><TD><P>10.4</P></TD><TD><P>16.0</P></TD><TD><P>1.8</P></TD><TD><P>1.8</P></TD></TR></TBODY></TABLE> Sat, 16 Nov 2024 04:31:18 GMT sri 2024-11-16T04:31:18Z Bar Chart with multiple column names as dimensions https://community.qlik.com/t5/QlikView/Bar-Chart-with-multiple-column-names-as-dimensions/m-p/1541212#M743420 <P>Hello,</P><P>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.&nbsp; &nbsp;For example, with the below data for x-axis with value Range1 -&gt; y- axis with value MI will have Data Point as 15.3 (1.5 + 2 + 11.8)&nbsp;</P><P>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.&nbsp; Thank you in advance!</P><TABLE><TBODY><TR><TD><P>State</P></TD><TD><P>Range1</P></TD><TD><P>Range2</P></TD><TD><P>Range3</P></TD><TD><P>Range4</P></TD><TD><P>Range5</P></TD><TD><P>Range6</P></TD><TD><P>Range7</P></TD><TD><P>Range8</P></TD><TD><P>Range9</P></TD></TR><TR><TD><P>MI</P></TD><TD><P>1.5</P></TD><TD><P>4.58</P></TD><TD><P>2.8</P></TD><TD><P>5.6</P></TD><TD><P>5.5</P></TD><TD><P>4.58</P></TD><TD><P>2.8</P></TD><TD><P>5.6</P></TD><TD><P>5.6</P></TD></TR><TR><TD><P>MI</P></TD><TD><P>2</P></TD><TD><P>27.8</P></TD><TD><P>2.6</P></TD><TD><P>10.8</P></TD><TD><P>2.6</P></TD><TD><P>27.8</P></TD><TD><P>2.6</P></TD><TD><P>10.8</P></TD><TD><P>10.8</P></TD></TR><TR><TD><P>OH</P></TD><TD><P>3.5</P></TD><TD><P>9.0</P></TD><TD><P>11.5</P></TD><TD><P>35.0</P></TD><TD><P>2.6</P></TD><TD><P>9.0</P></TD><TD><P>11.5</P></TD><TD><P>35.0</P></TD><TD><P>35.0</P></TD></TR><TR><TD><P>MI</P></TD><TD><P>11.8</P></TD><TD><P>0.5</P></TD><TD><P>16.9</P></TD><TD><P>25.5</P></TD><TD><P>12.5</P></TD><TD><P>0.5</P></TD><TD><P>16.9</P></TD><TD><P>25.5</P></TD><TD><P>25.5</P></TD></TR><TR><TD><P>KY</P></TD><TD><P>32.6</P></TD><TD><P>19.9</P></TD><TD><P>45.6</P></TD><TD><P>11.0</P></TD><TD><P>15.0</P></TD><TD><P>19.9</P></TD><TD><P>45.6</P></TD><TD><P>11.0</P></TD><TD><P>11.0</P></TD></TR><TR><TD><P>KY</P></TD><TD><P>5.7</P></TD><TD><P>16.1</P></TD><TD><P>1.8</P></TD><TD><P>5.6</P></TD><TD><P>11.8</P></TD><TD><P>16.1</P></TD><TD><P>1.8</P></TD><TD><P>5.6</P></TD><TD><P>5.6</P></TD></TR><TR><TD><P>AZ</P></TD><TD><P>3.8</P></TD><TD><P>10.4</P></TD><TD><P>16.0</P></TD><TD><P>1.8</P></TD><TD><P>35.5</P></TD><TD><P>10.4</P></TD><TD><P>16.0</P></TD><TD><P>1.8</P></TD><TD><P>1.8</P></TD></TR></TBODY></TABLE> Sat, 16 Nov 2024 04:31:18 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-with-multiple-column-names-as-dimensions/m-p/1541212#M743420 sri 2024-11-16T04:31:18Z