topic Stack chart with $$ Yaxis and Comp. Rate % on bar in QlikView https://community.qlik.com/t5/QlikView/Stack-chart-with-Yaxis-and-Comp-Rate-on-bar/m-p/232076#M83748 <HTML><HEAD></HEAD><BODY><P style="margin:0in 0in 0pt;">Hi Karen,</P><P style="margin:0in 0in 0pt;"></P><P style="margin:0in 0in 0pt;">I think you can get close. Use a combo chart.</P><P style="margin:0in 0in 0pt;"></P><P style="margin:0in 0in 0pt;">On the 'style' tab, set your bar style to stacked.</P><P style="margin:0in 0in 0pt;"></P><P style="margin:0in 0in 0pt;">Create your set of measures in terms of dollars, and set all of their displays to 'bar' only.</P><P style="margin:0in 0in 0pt;"></P><P style="margin:0in 0in 0pt;">Create a second set of measures performing your relative calculation to express them as percentages, and set them all to 'line' only display, set 'values on data points', and set the 'invisible' box at the top. (the lines will be invisible, but the data point labels will remain); On the axis tab, set all of you line (%) measures to be on the 'right' axis, and hide it. (setting the 'hide axis' check box)</P><P style="margin:0in 0in 0pt;"></P><P style="margin:0in 0in 0pt;">I think that should get you in the neighborhood.</P><P></P></BODY></HTML> Fri, 23 Jul 2010 23:54:34 GMT 2010-07-23T23:54:34Z Stack chart with $$ Yaxis and Comp. Rate % on bar https://community.qlik.com/t5/QlikView/Stack-chart-with-Yaxis-and-Comp-Rate-on-bar/m-p/232075#M83747 <HTML><HEAD></HEAD><BODY><P>Trying to replicate this Excel stack chart in QV. Values on bars are Compositon Rate$ and Y axis is total sales value for MMYYYY.</P><P>Is this possible in th QV? I can create this chart in QV, but Y axis is displays % for composition rate. I can't figure out how to display sales value $$$.</P><P>. <IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-1988_sourceID:1988" /></P></BODY></HTML> Fri, 23 Jul 2010 15:07:06 GMT https://community.qlik.com/t5/QlikView/Stack-chart-with-Yaxis-and-Comp-Rate-on-bar/m-p/232075#M83747 karensmith 2010-07-23T15:07:06Z Stack chart with $$ Yaxis and Comp. Rate % on bar https://community.qlik.com/t5/QlikView/Stack-chart-with-Yaxis-and-Comp-Rate-on-bar/m-p/232076#M83748 <HTML><HEAD></HEAD><BODY><P style="margin:0in 0in 0pt;">Hi Karen,</P><P style="margin:0in 0in 0pt;"></P><P style="margin:0in 0in 0pt;">I think you can get close. Use a combo chart.</P><P style="margin:0in 0in 0pt;"></P><P style="margin:0in 0in 0pt;">On the 'style' tab, set your bar style to stacked.</P><P style="margin:0in 0in 0pt;"></P><P style="margin:0in 0in 0pt;">Create your set of measures in terms of dollars, and set all of their displays to 'bar' only.</P><P style="margin:0in 0in 0pt;"></P><P style="margin:0in 0in 0pt;">Create a second set of measures performing your relative calculation to express them as percentages, and set them all to 'line' only display, set 'values on data points', and set the 'invisible' box at the top. (the lines will be invisible, but the data point labels will remain); On the axis tab, set all of you line (%) measures to be on the 'right' axis, and hide it. (setting the 'hide axis' check box)</P><P style="margin:0in 0in 0pt;"></P><P style="margin:0in 0in 0pt;">I think that should get you in the neighborhood.</P><P></P></BODY></HTML> Fri, 23 Jul 2010 23:54:34 GMT https://community.qlik.com/t5/QlikView/Stack-chart-with-Yaxis-and-Comp-Rate-on-bar/m-p/232076#M83748 2010-07-23T23:54:34Z