topic Re: Help in bar chart in QlikView https://community.qlik.com/t5/QlikView/Help-in-bar-chart/m-p/1228784#M855415 <HTML><HEAD></HEAD><BODY><P>Valuelist means you can get some nice simple labels which I prefer, bit more of a fiddly setup so depends what you want really!</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/153785_Capture.PNG" style="height: 402px; width: 620px;" /></P></BODY></HTML> Mon, 20 Feb 2017 15:03:25 GMT adamdavi3s 2017-02-20T15:03:25Z Help in bar chart https://community.qlik.com/t5/QlikView/Help-in-bar-chart/m-p/1228779#M855410 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P>I am new to qlikview. I have a requirement where i have 4 columns as below<SPAN style="font-size: 10pt;"> </SPAN></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="562"><TBODY><TR><TD class="xl64" height="20" width="155">Created to Approved</TD><TD class="xl64" style="border-left: none;" width="195">Approved To Master-Staging</TD><TD class="xl64" style="border-left: none;" width="148">Master-Staging to Master</TD><TD class="xl64" style="border-left: none;" width="64">Total Time</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">0.04</TD><TD class="xl63" style="border-top: none; border-left: none;">3.82</TD><TD class="xl63" style="border-top: none; border-left: none;">0.75</TD><TD class="xl63" style="border-top: none; border-left: none;">4.60</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">14.07</TD><TD class="xl63" style="border-top: none; border-left: none;">0.00</TD><TD class="xl63" style="border-top: none; border-left: none;">4.09</TD><TD class="xl63" style="border-top: none; border-left: none;">18.17</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">1.77</TD><TD class="xl63" style="border-top: none; border-left: none;">0.51</TD><TD class="xl63" style="border-top: none; border-left: none;">4.29</TD><TD class="xl63" style="border-top: none; border-left: none;">6.58</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">6.96</TD><TD class="xl63" style="border-top: none; border-left: none;">0.00</TD><TD class="xl63" style="border-top: none; border-left: none;">4.56</TD><TD class="xl63" style="border-top: none; border-left: none;">11.52</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">0.25</TD><TD class="xl63" style="border-top: none; border-left: none;">0.00</TD><TD class="xl63" style="border-top: none; border-left: none;">4.58</TD><TD class="xl63" style="border-top: none; border-left: none;">4.82</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">2.13</TD><TD class="xl63" style="border-top: none; border-left: none;">0.00</TD><TD class="xl63" style="border-top: none; border-left: none;">4.62</TD><TD class="xl63" style="border-top: none; border-left: none;">6.75</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">0.79</TD><TD class="xl63" style="border-top: none; border-left: none;">0.00</TD><TD class="xl63" style="border-top: none; border-left: none;">4.63</TD><TD class="xl63" style="border-top: none; border-left: none;">5.42</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">9.61</TD><TD class="xl63" style="border-top: none; border-left: none;">0.07</TD><TD class="xl63" style="border-top: none; border-left: none;">4.64</TD><TD class="xl63" style="border-top: none; border-left: none;">14.32</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">10.78</TD><TD class="xl63" style="border-top: none; border-left: none;">0.00</TD><TD class="xl63" style="border-top: none; border-left: none;">4.69</TD><TD class="xl63" style="border-top: none; border-left: none;">15.47</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">0.70</TD><TD class="xl63" style="border-top: none; border-left: none;">0.21</TD><TD class="xl63" style="border-top: none; border-left: none;">5.04</TD><TD class="xl63" style="border-top: none; border-left: none;">5.95</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">14.68</TD><TD class="xl63" style="border-top: none; border-left: none;">1.43</TD><TD class="xl63" style="border-top: none; border-left: none;">5.23</TD><TD class="xl63" style="border-top: none; border-left: none;">21.34</TD></TR></TBODY></TABLE><P></P><P>I need to produce the graph as below:</P><P>Can you please help me here:</P><P>these are the AVERAGE of the individual columns</P><P><IMG __jive_id="153774" alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/153774_Untitled.png" style="height: 280px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Help-in-bar-chart/m-p/1228779#M855410 sayadutt 2020-11-25T16:16:04Z Re: Help in bar chart https://community.qlik.com/t5/QlikView/Help-in-bar-chart/m-p/1228780#M855411 <HTML><HEAD></HEAD><BODY><P>just use the formula avg(columnname) as your expression for each column</P></BODY></HTML> Mon, 20 Feb 2017 14:37:31 GMT https://community.qlik.com/t5/QlikView/Help-in-bar-chart/m-p/1228780#M855411 adamdavi3s 2017-02-20T14:37:31Z Re: Help in bar chart https://community.qlik.com/t5/QlikView/Help-in-bar-chart/m-p/1228781#M855412 <HTML><HEAD></HEAD><BODY><P>Thanks Adam.</P><P>What should I use in Dimension?</P></BODY></HTML> Mon, 20 Feb 2017 14:44:04 GMT https://community.qlik.com/t5/QlikView/Help-in-bar-chart/m-p/1228781#M855412 sayadutt 2017-02-20T14:44:04Z Re: Help in bar chart https://community.qlik.com/t5/QlikView/Help-in-bar-chart/m-p/1228782#M855413 <HTML><HEAD></HEAD><BODY><P>I wouldn't use anything, I don't think you will need one?</P><P>If you do then use valuelist, will try it out in a sec</P></BODY></HTML> Mon, 20 Feb 2017 14:49:08 GMT https://community.qlik.com/t5/QlikView/Help-in-bar-chart/m-p/1228782#M855413 adamdavi3s 2017-02-20T14:49:08Z Re: Help in bar chart https://community.qlik.com/t5/QlikView/Help-in-bar-chart/m-p/1228783#M855414 <HTML><HEAD></HEAD><BODY><P>You can leave it empty.</P></BODY></HTML> Mon, 20 Feb 2017 14:49:37 GMT https://community.qlik.com/t5/QlikView/Help-in-bar-chart/m-p/1228783#M855414 2017-02-20T14:49:37Z Re: Help in bar chart https://community.qlik.com/t5/QlikView/Help-in-bar-chart/m-p/1228784#M855415 <HTML><HEAD></HEAD><BODY><P>Valuelist means you can get some nice simple labels which I prefer, bit more of a fiddly setup so depends what you want really!</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/153785_Capture.PNG" style="height: 402px; width: 620px;" /></P></BODY></HTML> Mon, 20 Feb 2017 15:03:25 GMT https://community.qlik.com/t5/QlikView/Help-in-bar-chart/m-p/1228784#M855415 adamdavi3s 2017-02-20T15:03:25Z