https://community.qlik.com/t5/App-Development/How-to-calculate-the-highest-value-per-week-period/m-p/1729761#M55649 <P>What if you use <EM>YearWeek</EM> as a dimension in your chart and <EM>Max(Reading)</EM> as a measure?</P><P>If you don't have a Year Week field name you can create one in the script using the <A href="https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFunctions/weekname.htm" target="_self">WeekName()</A> function.&nbsp;</P> Wed, 22 Jul 2020 05:00:24 GMT Vegar 2020-07-22T05:00:24Z https://community.qlik.com/t5/App-Development/How-to-calculate-the-highest-value-per-week-period/m-p/1729754#M55648 <P>Hello!</P><P>I want to calculate the highest value per week on a chart. I have a data set as you can see on my screenshot. The data set 'Reading' hits high and low values every day and is separated by weeks. I would like to show the<SPAN>&nbsp;</SPAN><STRONG>highest</STRONG><SPAN>&nbsp;</SPAN>point (max value) of<SPAN>&nbsp;</SPAN><STRONG>each week period or two week period</STRONG>. What's the best expression/chart to express this?</P><P>For example:</P><P>week 1 (04/28) the highest value of max value, 4.08</P><P>week 2 (05/12) the highest value, 4.73 and so on via a visual chart.&nbsp;</P><P><BR />Any help is greatly appreciated!</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="data2.PNG" style="width: 615px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/37849i0E1F55245297BCE1/image-size/large?v=v2&amp;px=999" role="button" title="data2.PNG" alt="data2.PNG" /></span></P><P>&nbsp;</P> Wed, 22 Jul 2020 04:19:58 GMT https://community.qlik.com/t5/App-Development/How-to-calculate-the-highest-value-per-week-period/m-p/1729754#M55648 wholelottared 2020-07-22T04:19:58Z https://community.qlik.com/t5/App-Development/How-to-calculate-the-highest-value-per-week-period/m-p/1729761#M55649 <P>What if you use <EM>YearWeek</EM> as a dimension in your chart and <EM>Max(Reading)</EM> as a measure?</P><P>If you don't have a Year Week field name you can create one in the script using the <A href="https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFunctions/weekname.htm" target="_self">WeekName()</A> function.&nbsp;</P> Wed, 22 Jul 2020 05:00:24 GMT https://community.qlik.com/t5/App-Development/How-to-calculate-the-highest-value-per-week-period/m-p/1729761#M55649 Vegar 2020-07-22T05:00:24Z