https://community.qlik.com/t5/App-Development/Stacked-Bar-Chart/m-p/1690452#M52752 <P>Hello Experts!</P><P>I am struggling to have this particular data in my stacked bar chart</P><P>I have 2 dimensions 'Categories' and 'Week Num' which are stacked against the measure 'AWO'. I want only the data for 'Friday' of each week to be displayed and when in current week, the current dates Data has&nbsp; to be displayed .</P><P>I did it by creating Master dimension&nbsp;=If([Weekly Data]='Fri',[Week Num]) which works fine till week 13. How do I include Todays Data(02/04/2020) in week 14 column?</P><P>Also For Category whose value is 'Closed', I want to have cumulative sum in the same chart. Is it possible to do this?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Stacked Bar.jpg" style="width: 743px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/31153iDFB4F3D9CD4A839F/image-size/large?v=v2&amp;px=999" role="button" title="Stacked Bar.jpg" alt="Stacked Bar.jpg" /></span></P> Wed, 22 Dec 2021 16:34:21 GMT a_shetty 2021-12-22T16:34:21Z https://community.qlik.com/t5/App-Development/Stacked-Bar-Chart/m-p/1690452#M52752 <P>Hello Experts!</P><P>I am struggling to have this particular data in my stacked bar chart</P><P>I have 2 dimensions 'Categories' and 'Week Num' which are stacked against the measure 'AWO'. I want only the data for 'Friday' of each week to be displayed and when in current week, the current dates Data has&nbsp; to be displayed .</P><P>I did it by creating Master dimension&nbsp;=If([Weekly Data]='Fri',[Week Num]) which works fine till week 13. How do I include Todays Data(02/04/2020) in week 14 column?</P><P>Also For Category whose value is 'Closed', I want to have cumulative sum in the same chart. Is it possible to do this?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Stacked Bar.jpg" style="width: 743px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/31153iDFB4F3D9CD4A839F/image-size/large?v=v2&amp;px=999" role="button" title="Stacked Bar.jpg" alt="Stacked Bar.jpg" /></span></P> Wed, 22 Dec 2021 16:34:21 GMT https://community.qlik.com/t5/App-Development/Stacked-Bar-Chart/m-p/1690452#M52752 a_shetty 2021-12-22T16:34:21Z