topic Only display maximum value of dimension in chart in QlikView https://community.qlik.com/t5/QlikView/Only-display-maximum-value-of-dimension-in-chart/m-p/104579#M751631 <HTML><HEAD></HEAD><BODY><P>I have a stacked bar chart with two dimensions. First, week formatted as an integer YYYYWW and then a category as string. I want to show only the latest week in the loaded data. (Not last week since the data from last week might not be loaded yet.)</P><P></P><P>How would I do that?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT marcusbohman 2020-11-25T16:16:04Z Only display maximum value of dimension in chart https://community.qlik.com/t5/QlikView/Only-display-maximum-value-of-dimension-in-chart/m-p/104579#M751631 <HTML><HEAD></HEAD><BODY><P>I have a stacked bar chart with two dimensions. First, week formatted as an integer YYYYWW and then a category as string. I want to show only the latest week in the loaded data. (Not last week since the data from last week might not be loaded yet.)</P><P></P><P>How would I do that?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Only-display-maximum-value-of-dimension-in-chart/m-p/104579#M751631 marcusbohman 2020-11-25T16:16:04Z Re: Only display maximum value of dimension in chart https://community.qlik.com/t5/QlikView/Only-display-maximum-value-of-dimension-in-chart/m-p/104580#M751634 <HTML><HEAD></HEAD><BODY><P>Use Set Analysis in your chart expression/ measure, for example <EM>=Sum({&lt;WeekYear = {"$(=Max(WeekYear ))<SPAN style="font-weight: inherit; font-family: inherit; color: #ff0000;">"</SPAN>}&gt;} Sales)</EM></P></BODY></HTML> Sun, 04 Nov 2018 19:44:06 GMT https://community.qlik.com/t5/QlikView/Only-display-maximum-value-of-dimension-in-chart/m-p/104580#M751634 vunguyenq89 2018-11-04T19:44:06Z Re: Only display maximum value of dimension in chart https://community.qlik.com/t5/QlikView/Only-display-maximum-value-of-dimension-in-chart/m-p/104581#M751636 <HTML><HEAD></HEAD><BODY><P>Perfect!</P></BODY></HTML> Sun, 04 Nov 2018 19:55:04 GMT https://community.qlik.com/t5/QlikView/Only-display-maximum-value-of-dimension-in-chart/m-p/104581#M751636 marcusbohman 2018-11-04T19:55:04Z