https://community.qlik.com/t5/App-Development/Divided-the-calculated-value-in-stacked-bar-chart/m-p/2056144#M86755 <P>Hello,</P> <P>I need to make color separation in stacked bar chart.</P> <P>I have following data:</P> <P>ID of item&nbsp; &nbsp; &nbsp; &nbsp; Day capacity&nbsp; &nbsp; &nbsp; Worked hours&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Status</P> <P>&nbsp; &nbsp; &nbsp;001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;17&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;13&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;efective</P> <P>&nbsp; &nbsp; &nbsp;002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;17&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;non efective</P> <P>I would like to make stacked bar chart like this:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="jozisvk11_0-1680518504006.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/104040i2055FC70893F34DE/image-size/medium?v=v2&amp;px=400" role="button" title="jozisvk11_0-1680518504006.png" alt="jozisvk11_0-1680518504006.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Explanation: First blue column means Day capacity and second purple color means efective hour and darker purple means non efective hours.&nbsp;</P> <P>Thank you for helping me.</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 03 Apr 2023 10:43:29 GMT jozisvk11 2023-04-03T10:43:29Z https://community.qlik.com/t5/App-Development/Divided-the-calculated-value-in-stacked-bar-chart/m-p/2056144#M86755 <P>Hello,</P> <P>I need to make color separation in stacked bar chart.</P> <P>I have following data:</P> <P>ID of item&nbsp; &nbsp; &nbsp; &nbsp; Day capacity&nbsp; &nbsp; &nbsp; Worked hours&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Status</P> <P>&nbsp; &nbsp; &nbsp;001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;17&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;13&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;efective</P> <P>&nbsp; &nbsp; &nbsp;002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;17&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;non efective</P> <P>I would like to make stacked bar chart like this:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="jozisvk11_0-1680518504006.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/104040i2055FC70893F34DE/image-size/medium?v=v2&amp;px=400" role="button" title="jozisvk11_0-1680518504006.png" alt="jozisvk11_0-1680518504006.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Explanation: First blue column means Day capacity and second purple color means efective hour and darker purple means non efective hours.&nbsp;</P> <P>Thank you for helping me.</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 03 Apr 2023 10:43:29 GMT https://community.qlik.com/t5/App-Development/Divided-the-calculated-value-in-stacked-bar-chart/m-p/2056144#M86755 jozisvk11 2023-04-03T10:43:29Z