topic Re: Show dimension in Bar chart expression in QlikView https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1158990#M377827 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Have you tried <STRONG>=avg(employee).</STRONG></P><P><STRONG><BR /></STRONG></P><P>​I hope that helps</P></BODY></HTML> Wed, 07 Sep 2016 11:39:08 GMT Anonymous 2016-09-07T11:39:08Z Show dimension in Bar chart expression https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1158989#M377826 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have to show dimension in expression without aggregation function.</P><P></P><P>Like i have 3 columns.</P><P></P><P>2 columns added under dimension in chart property but i have to show 3rd dimension in expression without aggregation.Actually i have to shoe employee name on bar chart value point.</P><P></P><P>=count(employee) is working but =employee is not working??</P><P></P><P>How i can use dimension in expression directly??</P><P></P><P></P><P>Thanks ,</P><P></P><P>Narender</P></BODY></HTML> Wed, 07 Sep 2016 11:35:35 GMT https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1158989#M377826 narender123 2016-09-07T11:35:35Z Re: Show dimension in Bar chart expression https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1158990#M377827 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Have you tried <STRONG>=avg(employee).</STRONG></P><P><STRONG><BR /></STRONG></P><P>​I hope that helps</P></BODY></HTML> Wed, 07 Sep 2016 11:39:08 GMT https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1158990#M377827 Anonymous 2016-09-07T11:39:08Z Re: Show dimension in Bar chart expression https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1158991#M377828 <HTML><HEAD></HEAD><BODY><P>No , Its not working.</P></BODY></HTML> Wed, 07 Sep 2016 11:41:19 GMT https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1158991#M377828 narender123 2016-09-07T11:41:19Z Re: Show dimension in Bar chart expression https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1158992#M377829 <HTML><HEAD></HEAD><BODY><P>=only(employee)</P></BODY></HTML> Wed, 07 Sep 2016 11:42:31 GMT https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1158992#M377829 Anonymous 2016-09-07T11:42:31Z Re: Show dimension in Bar chart expression https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1158993#M377830 <HTML><HEAD></HEAD><BODY><P>Thanks Balraj,</P><P></P><P>Actually i have data in employee column like</P><P></P><P></P><P>5 employee</P><P>10 employee</P><P></P><P>so its is not working.</P></BODY></HTML> Wed, 07 Sep 2016 11:48:04 GMT https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1158993#M377830 narender123 2016-09-07T11:48:04Z Re: Show dimension in Bar chart expression https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1158994#M377831 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Thanks,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Actually i have data in employee column like</P><P></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">5 employee</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">10 employee</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">so its is not working.</P></BODY></HTML> Wed, 07 Sep 2016 11:49:24 GMT https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1158994#M377831 narender123 2016-09-07T11:49:24Z Re: Show dimension in Bar chart expression https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1158995#M377832 <HTML><HEAD></HEAD><BODY><P>Could you show me a picture of what you have at the moment? I am confused as to what you want. You have a bar chart showing something and you want to add a name on each bar?</P></BODY></HTML> Wed, 07 Sep 2016 12:04:46 GMT https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1158995#M377832 ThornOfCrowns 2016-09-07T12:04:46Z Re: Show dimension in Bar chart expression https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1158996#M377833 <HTML><HEAD></HEAD><BODY><P>did u tried</P><P></P><P>=valuelist(Employee)</P></BODY></HTML> Wed, 07 Sep 2016 12:06:41 GMT https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1158996#M377833 Chanty4u 2016-09-07T12:06:41Z Re: Show dimension in Bar chart expression https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1158997#M377834 <HTML><HEAD></HEAD><BODY><P>any sample data?</P></BODY></HTML> Wed, 07 Sep 2016 12:48:32 GMT https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1158997#M377834 Anonymous 2016-09-07T12:48:32Z Re: Show dimension in Bar chart expression https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1158998#M377835 <HTML><HEAD></HEAD><BODY><P>PFA.</P></BODY></HTML> Wed, 07 Sep 2016 12:59:40 GMT https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1158998#M377835 narender123 2016-09-07T12:59:40Z Re: Show dimension in Bar chart expression https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1158999#M377836 <HTML><HEAD></HEAD><BODY><P>Please find attached file shared with Balraj.</P></BODY></HTML> Wed, 07 Sep 2016 13:00:18 GMT https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1158999#M377836 narender123 2016-09-07T13:00:18Z Re: Show dimension in Bar chart expression https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1159000#M377837 <HTML><HEAD></HEAD><BODY><P>Will this work?</P><P></P><P>I doubt that we can write dimension value as it is in Chart expression but same can be done in report..</P></BODY></HTML> Wed, 07 Sep 2016 13:06:38 GMT https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1159000#M377837 Anonymous 2016-09-07T13:06:38Z Re: Show dimension in Bar chart expression https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1159001#M377838 <HTML><HEAD></HEAD><BODY><P>I know but i have to show it in bar chart.</P></BODY></HTML> Wed, 07 Sep 2016 13:09:49 GMT https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1159001#M377838 narender123 2016-09-07T13:09:49Z Re: Show dimension in Bar chart expression https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1159002#M377839 <HTML><HEAD></HEAD><BODY><P>hi Narender</P><P>use in expresion like this</P><P></P><P>=dual(Employees,sum(SubField(Employees,' ',1)))</P></BODY></HTML> Wed, 07 Sep 2016 13:55:20 GMT https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1159002#M377839 florentina_doga 2016-09-07T13:55:20Z Re: Show dimension in Bar chart expression https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1159003#M377840 <HTML><HEAD></HEAD><BODY><P>Then try This,</P></BODY></HTML> Wed, 07 Sep 2016 13:57:08 GMT https://community.qlik.com/t5/QlikView/Show-dimension-in-Bar-chart-expression/m-p/1159003#M377840 Anil_Babu_Samineni 2016-09-07T13:57:08Z