topic FOCUS VALUES ON A CHART in QlikView https://community.qlik.com/t5/QlikView/FOCUS-VALUES-ON-A-CHART/m-p/1341704#M413230 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>i have a bar chart with:</P><P>- Timing on X axis</P><P>- Energy on Y axis</P><P></P><P>The same project:</P><P>- on qlikview client show me the last values order by datetime (today 21/06/2017 - show me the last 3 days:&nbsp; 18/06/2017-21/06/2017)</P><P>- on qlikview web show me the first values order by datetime (<SPAN style="font-size: 13.3333px;">today 21/06/2017 - show me the first 3 days of data on the project:&nbsp; 25/05/2017-28/05/2017)</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Can you explain me why ? I want always the focus on the last days of data as in the client</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">This is the expression used for the ENERGY</SPAN></P><P><SPAN style="font-size: 13.3333px;">=Sum(Aggr( ( [DATETIME]= {"=Max([DATETIME])&gt;Date('$(dateVisualizeInChartHour)')"}&gt;} [ENERGY YELDED])), IDDE DAY,HOUR))</SPAN></P></BODY></HTML> Thu, 22 Jun 2017 10:51:41 GMT Anonymous 2017-06-22T10:51:41Z FOCUS VALUES ON A CHART https://community.qlik.com/t5/QlikView/FOCUS-VALUES-ON-A-CHART/m-p/1341704#M413230 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>i have a bar chart with:</P><P>- Timing on X axis</P><P>- Energy on Y axis</P><P></P><P>The same project:</P><P>- on qlikview client show me the last values order by datetime (today 21/06/2017 - show me the last 3 days:&nbsp; 18/06/2017-21/06/2017)</P><P>- on qlikview web show me the first values order by datetime (<SPAN style="font-size: 13.3333px;">today 21/06/2017 - show me the first 3 days of data on the project:&nbsp; 25/05/2017-28/05/2017)</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Can you explain me why ? I want always the focus on the last days of data as in the client</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">This is the expression used for the ENERGY</SPAN></P><P><SPAN style="font-size: 13.3333px;">=Sum(Aggr( ( [DATETIME]= {"=Max([DATETIME])&gt;Date('$(dateVisualizeInChartHour)')"}&gt;} [ENERGY YELDED])), IDDE DAY,HOUR))</SPAN></P></BODY></HTML> Thu, 22 Jun 2017 10:51:41 GMT https://community.qlik.com/t5/QlikView/FOCUS-VALUES-ON-A-CHART/m-p/1341704#M413230 Anonymous 2017-06-22T10:51:41Z