topic Re: Set Analysis Query in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-Query/m-p/553325#M206739 <HTML><HEAD></HEAD><BODY><P>Is this what you want?</P><P></P><P>PFA.</P></BODY></HTML> Fri, 02 Aug 2013 12:05:11 GMT tresB 2013-08-02T12:05:11Z Set Analysis Query https://community.qlik.com/t5/QlikView/Set-Analysis-Query/m-p/553324#M206738 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Hopefully I'm clear in explaining this complex problem. </P><P></P><P>I have a grid with some data and some filters at the top. </P><P></P><P>On button's action, it filters the data by dates. Here I would like to add another expression to pick the latest record (latest age of break) within the filtered data. Same unique ids, but latest age of break.</P><P></P><P>For e.g GGLXXXX54888EUR2889050110EUR_135695 has two records. When clicked on the button it will filter by dates and I would then like to pick the latest one (age of break = 2) from the filter.</P><P></P><P>Please look at the attached qvw.</P><P></P><P>Thanks for your help.</P></BODY></HTML> Fri, 02 Aug 2013 11:58:33 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Query/m-p/553324#M206738 2013-08-02T11:58:33Z Re: Set Analysis Query https://community.qlik.com/t5/QlikView/Set-Analysis-Query/m-p/553325#M206739 <HTML><HEAD></HEAD><BODY><P>Is this what you want?</P><P></P><P>PFA.</P></BODY></HTML> Fri, 02 Aug 2013 12:05:11 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Query/m-p/553325#M206739 tresB 2013-08-02T12:05:11Z Re: Set Analysis Query https://community.qlik.com/t5/QlikView/Set-Analysis-Query/m-p/553326#M206740 <HTML><HEAD></HEAD><BODY><P>Thanks.</P><P></P><P>Although that will give me latest ir-respective of unique Ids. If I clear all and just get latest age, it will be ignore all unique Ids and find the latest age.</P><P></P><P>I'd like latest age for each unique Id.</P></BODY></HTML> Fri, 02 Aug 2013 12:21:53 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Query/m-p/553326#M206740 2013-08-02T12:21:53Z Re: Set Analysis Query https://community.qlik.com/t5/QlikView/Set-Analysis-Query/m-p/553327#M206741 <HTML><HEAD></HEAD><BODY><P>No need to create button for max of Age</P><P></P><P>See the attached one</P></BODY></HTML> Fri, 02 Aug 2013 12:23:49 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Query/m-p/553327#M206741 Kushal_Chawda 2013-08-02T12:23:49Z Re: Set Analysis Query https://community.qlik.com/t5/QlikView/Set-Analysis-Query/m-p/553328#M206742 <HTML><HEAD></HEAD><BODY><P>this?</P><P></P><P>PFA</P></BODY></HTML> Fri, 02 Aug 2013 13:03:39 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Query/m-p/553328#M206742 tresB 2013-08-02T13:03:39Z