topic Re: Bar Chart with No Dimensions and Multiple Expressions in QlikView https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967863#M529166 <HTML><HEAD></HEAD><BODY><P>I have the standard in a variable already - just looking to see how to manage the graph to show both my expression and my variable.</P></BODY></HTML> Thu, 20 Aug 2015 20:11:11 GMT 2015-08-20T20:11:11Z Bar Chart with No Dimensions and Multiple Expressions https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967859#M529162 <HTML><HEAD></HEAD><BODY><P>Good Afternoon -</P><P></P><P>I have a simple bar chart with no dimensions and multiple expressions (as my data is in different columns) and I'm trying to figure out how to not only show the actual value but include an industry benchmark.&nbsp; Much appreciate any help!!!!</P><P></P><P>This is what I have </P><P><IMG alt="Current Chart.png" class="jive-image image-1" src="/legacyfs/online/96614_Current Chart.png" style="height: auto;" /></P><P>This what I want</P><P><IMG alt="Future Chart.png" class="jive-image image-2" src="/legacyfs/online/96615_Future Chart.png" style="height: auto;" /></P></BODY></HTML> Thu, 20 Aug 2015 18:33:31 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967859#M529162 2015-08-20T18:33:31Z Re: Bar Chart with No Dimensions and Multiple Expressions https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967860#M529163 <HTML><HEAD></HEAD><BODY><P>You want to manually add industry&nbsp; standards or are they already available in your data?</P></BODY></HTML> Thu, 20 Aug 2015 19:05:44 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967860#M529163 chaper 2015-08-20T19:05:44Z Re: Bar Chart with No Dimensions and Multiple Expressions https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967861#M529164 <HTML><HEAD></HEAD><BODY><P>If you already have in data try the combo chart and show the industry standards as line.</P></BODY></HTML> Thu, 20 Aug 2015 19:09:06 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967861#M529164 chaper 2015-08-20T19:09:06Z Re: Bar Chart with No Dimensions and Multiple Expressions https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967862#M529165 <HTML><HEAD></HEAD><BODY><P>Please provide sample data</P></BODY></HTML> Thu, 20 Aug 2015 19:12:45 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967862#M529165 Kushal_Chawda 2015-08-20T19:12:45Z Re: Bar Chart with No Dimensions and Multiple Expressions https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967863#M529166 <HTML><HEAD></HEAD><BODY><P>I have the standard in a variable already - just looking to see how to manage the graph to show both my expression and my variable.</P></BODY></HTML> Thu, 20 Aug 2015 20:11:11 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967863#M529166 2015-08-20T20:11:11Z Re: Bar Chart with No Dimensions and Multiple Expressions https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967864#M529167 <HTML><HEAD></HEAD><BODY><P>Did you tried Combo chart?Provide sample data or app?</P></BODY></HTML> Thu, 20 Aug 2015 20:13:22 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967864#M529167 chaper 2015-08-20T20:13:22Z Re: Bar Chart with No Dimensions and Multiple Expressions https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967865#M529168 <HTML><HEAD></HEAD><BODY><P>Forgot to mention that each bar has it's own standard so one line for the entire chart is not going to work.&nbsp; I need a different value to show in each bar.</P></BODY></HTML> Thu, 20 Aug 2015 20:13:32 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967865#M529168 2015-08-20T20:13:32Z Re: Bar Chart with No Dimensions and Multiple Expressions https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967866#M529169 <HTML><HEAD></HEAD><BODY><P>So standard is not connected any data element?</P></BODY></HTML> Thu, 20 Aug 2015 20:15:33 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967866#M529169 chaper 2015-08-20T20:15:33Z Re: Bar Chart with No Dimensions and Multiple Expressions https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967867#M529170 <HTML><HEAD></HEAD><BODY><P>No - it's stored in a varable</P></BODY></HTML> Thu, 20 Aug 2015 20:16:14 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967867#M529170 2015-08-20T20:16:14Z Re: Bar Chart with No Dimensions and Multiple Expressions https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967868#M529171 <HTML><HEAD></HEAD><BODY><P>Correct - it's not tied to any data element</P></BODY></HTML> Thu, 20 Aug 2015 20:16:32 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967868#M529171 2015-08-20T20:16:32Z Re: Bar Chart with No Dimensions and Multiple Expressions https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967869#M529172 <HTML><HEAD></HEAD><BODY><P>Connect the standard values(as Excel or Inline) to data through dimension or date .Then you can easily plot the standard values.If you can't connect to data other option is add calculated expression ex:if (Dimesion='SBE','6.5%') and display it as text as popup.Downside is you won't see number in chart until you hover over each bar.</P></BODY></HTML> Thu, 20 Aug 2015 20:24:16 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967869#M529172 chaper 2015-08-20T20:24:16Z Re: Bar Chart with No Dimensions and Multiple Expressions https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967870#M529173 <HTML><HEAD></HEAD><BODY><P>Post a sample app or data</P></BODY></HTML> Thu, 20 Aug 2015 20:25:52 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967870#M529173 chaper 2015-08-20T20:25:52Z Re: Bar Chart with No Dimensions and Multiple Expressions https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967871#M529174 <HTML><HEAD></HEAD><BODY><P>Here you go....I'm looking to have Standard_A displayed within the A bar, and so on.</P></BODY></HTML> Thu, 20 Aug 2015 20:27:04 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967871#M529174 2015-08-20T20:27:04Z Re: Bar Chart with No Dimensions and Multiple Expressions https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967872#M529175 <HTML><HEAD></HEAD><BODY><P>I used Inline table</P></BODY></HTML> Thu, 20 Aug 2015 20:45:48 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967872#M529175 chaper 2015-08-20T20:45:48Z Re: Bar Chart with No Dimensions and Multiple Expressions https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967873#M529176 <HTML><HEAD></HEAD><BODY><P>How would you do in without Inline as my data in the graph is made up of 15 different expressions</P></BODY></HTML> Thu, 20 Aug 2015 20:50:14 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967873#M529176 2015-08-20T20:50:14Z Re: Bar Chart with No Dimensions and Multiple Expressions https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967874#M529177 <HTML><HEAD></HEAD><BODY><P>Inline is similar to your excel file I added Standards to respective Fields(A,B,C,D) instead of variables.If you post real sample application with 15 expressions then I can look into.</P></BODY></HTML> Thu, 20 Aug 2015 20:56:08 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967874#M529177 chaper 2015-08-20T20:56:08Z Re: Bar Chart with No Dimensions and Multiple Expressions https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967875#M529178 <HTML><HEAD></HEAD><BODY><P>Thx Chai - appreciate the time and help.&nbsp; I've found an alternative to displaying the benchmarks but will try to post something as soon as I can as I know this will come up again for me.</P></BODY></HTML> Thu, 20 Aug 2015 20:58:21 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967875#M529178 2015-08-20T20:58:21Z Re: Bar Chart with No Dimensions and Multiple Expressions https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967876#M529179 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/96620_Capture.JPG" style="height: 407px; width: 620px;" /></P><P>I got the wrong graph in app.The bar chart will look like this</P></BODY></HTML> Thu, 20 Aug 2015 20:58:28 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967876#M529179 chaper 2015-08-20T20:58:28Z Re: Bar Chart with No Dimensions and Multiple Expressions https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967877#M529180 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>As suggested use combo chart and make the line expression as invisible in the expressions tab then you won't get the line.</P><P></P><P>Hope it helps .</P><P></P><P>KK</P></BODY></HTML> Fri, 21 Aug 2015 13:05:35 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967877#M529180 kkkumar82 2015-08-21T13:05:35Z Re: Bar Chart with No Dimensions and Multiple Expressions https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967878#M529181 <HTML><HEAD></HEAD><BODY><P>Thanks KK - how ever a combo chart is not going to work as I do not have any Dimensions and 15 expressions representing 15 different results. </P></BODY></HTML> Fri, 21 Aug 2015 13:11:12 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-with-No-Dimensions-and-Multiple-Expressions/m-p/967878#M529181 2015-08-21T13:11:12Z