topic Wrong data is getting calculated in chart in QlikView https://community.qlik.com/t5/QlikView/Wrong-data-is-getting-calculated-in-chart/m-p/67839#M767353 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>I have sample data like this .</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/205981_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>in expression I wrote max(endtime) - min(starttime) ,when I plot a chart , it is considering all the rows (10 rows) data .</P><P>However I want to show only highlight data difference .</P><P><IMG class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/206001_pastedImage_2.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/206000_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P><P>Please let me know where I am doing wrong.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT ashis 2020-11-25T16:16:04Z Wrong data is getting calculated in chart https://community.qlik.com/t5/QlikView/Wrong-data-is-getting-calculated-in-chart/m-p/67839#M767353 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>I have sample data like this .</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/205981_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>in expression I wrote max(endtime) - min(starttime) ,when I plot a chart , it is considering all the rows (10 rows) data .</P><P>However I want to show only highlight data difference .</P><P><IMG class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/206001_pastedImage_2.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/206000_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P><P>Please let me know where I am doing wrong.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Wrong-data-is-getting-calculated-in-chart/m-p/67839#M767353 ashis 2020-11-25T16:16:04Z Re: Wrong data is getting calculated in chart https://community.qlik.com/t5/QlikView/Wrong-data-is-getting-calculated-in-chart/m-p/67840#M767354 <HTML><HEAD></HEAD><BODY><P>May be you should use AGGR function to aggregate data on your key field.</P></BODY></HTML> Fri, 22 Jun 2018 16:35:29 GMT https://community.qlik.com/t5/QlikView/Wrong-data-is-getting-calculated-in-chart/m-p/67840#M767354 Anonymous 2018-06-22T16:35:29Z