https://community.qlik.com/t5/QlikView/Data-filtering-in-chart/m-p/1568780#M441923 <P>Hi,</P><P>I want to filter the data&nbsp; for each Date based on maximum value of Issue Type field.</P><P>I have data like this:</P><TABLE><TBODY><TR><TD>Date</TD><TD>Issue Type</TD><TD>resolution time</TD></TR><TR><TD>4/12/2019</TD><TD>1</TD><TD>23</TD></TR><TR><TD>4/12/2019</TD><TD>2</TD><TD>56</TD></TR><TR><TD>4/13/2019</TD><TD>2</TD><TD>34</TD></TR><TR><TD>4/13/2019</TD><TD>4</TD><TD>78</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want to show in a&nbsp; chart like this:</P><TABLE><TBODY><TR><TD>Date</TD><TD>Issue Type</TD><TD>resolution time</TD></TR><TR><TD>4/12/2019</TD><TD>2</TD><TD>56</TD></TR><TR><TD>4/13/2019</TD><TD>4</TD><TD>78</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/46628">@sunny_talwar</a>&nbsp;,&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/14787">@maxgro</a>&nbsp;</P> Sat, 16 Nov 2024 03:52:15 GMT Prabhu 2024-11-16T03:52:15Z https://community.qlik.com/t5/QlikView/Data-filtering-in-chart/m-p/1568780#M441923 <P>Hi,</P><P>I want to filter the data&nbsp; for each Date based on maximum value of Issue Type field.</P><P>I have data like this:</P><TABLE><TBODY><TR><TD>Date</TD><TD>Issue Type</TD><TD>resolution time</TD></TR><TR><TD>4/12/2019</TD><TD>1</TD><TD>23</TD></TR><TR><TD>4/12/2019</TD><TD>2</TD><TD>56</TD></TR><TR><TD>4/13/2019</TD><TD>2</TD><TD>34</TD></TR><TR><TD>4/13/2019</TD><TD>4</TD><TD>78</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want to show in a&nbsp; chart like this:</P><TABLE><TBODY><TR><TD>Date</TD><TD>Issue Type</TD><TD>resolution time</TD></TR><TR><TD>4/12/2019</TD><TD>2</TD><TD>56</TD></TR><TR><TD>4/13/2019</TD><TD>4</TD><TD>78</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/46628">@sunny_talwar</a>&nbsp;,&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/14787">@maxgro</a>&nbsp;</P> Sat, 16 Nov 2024 03:52:15 GMT https://community.qlik.com/t5/QlikView/Data-filtering-in-chart/m-p/1568780#M441923 Prabhu 2024-11-16T03:52:15Z https://community.qlik.com/t5/QlikView/Data-filtering-in-chart/m-p/1568789#M441924 <P>Try this</P><P>Dimension</P><PRE>Date</PRE><P>Expression</P><PRE>Max([Issue Type]) FirstSortedValue([resolution time], -[Issue Type])</PRE> Fri, 12 Apr 2019 13:28:50 GMT https://community.qlik.com/t5/QlikView/Data-filtering-in-chart/m-p/1568789#M441924 sunny_talwar 2019-04-12T13:28:50Z https://community.qlik.com/t5/QlikView/Data-filtering-in-chart/m-p/1568873#M441943 <P>Hi Sunny,</P><P>The second expression is working. But, is there any way to show "issue type" value as pop up or legend?</P> Fri, 12 Apr 2019 17:33:11 GMT https://community.qlik.com/t5/QlikView/Data-filtering-in-chart/m-p/1568873#M441943 Prabhu 2019-04-12T17:33:11Z https://community.qlik.com/t5/QlikView/Data-filtering-in-chart/m-p/1568913#M441944 <P>I am not sure I follow your question?</P> Fri, 12 Apr 2019 19:21:05 GMT https://community.qlik.com/t5/QlikView/Data-filtering-in-chart/m-p/1568913#M441944 sunny_talwar 2019-04-12T19:21:05Z