topic Re: help in set analysis in QlikView https://community.qlik.com/t5/QlikView/help-in-set-analysis/m-p/912144#M316534 <HTML><HEAD></HEAD><BODY><P>do you have master calendar?</P><P></P><P>If yes why don't you try with Max(Date)?</P></BODY></HTML> Wed, 05 Aug 2015 12:13:54 GMT Anonymous 2015-08-05T12:13:54Z help in set analysis https://community.qlik.com/t5/QlikView/help-in-set-analysis/m-p/912141#M316531 <HTML><HEAD></HEAD><BODY><P>Hello got the following sample data:</P><P>TPK, Date, Metric</P><P>A, 7/6/2015, 9</P><P>A,8/6/2015, 15</P><P>B,5/5/2015, 10</P><P>B, 6/5/2015, 7</P><P></P><P>now the user selects the months May and June</P><P>what I want to display in a pivot table (dimension = TPK) for A, 15 and for B, 7</P><P>i.e. the metric that corresponds to the latest date for each TPK in the selection</P></BODY></HTML> Wed, 05 Aug 2015 12:07:37 GMT https://community.qlik.com/t5/QlikView/help-in-set-analysis/m-p/912141#M316531 ali_hijazi 2015-08-05T12:07:37Z Re: help in set analysis https://community.qlik.com/t5/QlikView/help-in-set-analysis/m-p/912142#M316532 <HTML><HEAD></HEAD><BODY><P>Try this expression:</P><P></P><P><STRONG>=FirstSortedValue(Metric, -Date)</STRONG></P></BODY></HTML> Wed, 05 Aug 2015 12:10:32 GMT https://community.qlik.com/t5/QlikView/help-in-set-analysis/m-p/912142#M316532 sunny_talwar 2015-08-05T12:10:32Z Re: help in set analysis https://community.qlik.com/t5/QlikView/help-in-set-analysis/m-p/912143#M316533 <HTML><HEAD></HEAD><BODY><P>This:</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/95073_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 05 Aug 2015 12:13:19 GMT https://community.qlik.com/t5/QlikView/help-in-set-analysis/m-p/912143#M316533 sunny_talwar 2015-08-05T12:13:19Z Re: help in set analysis https://community.qlik.com/t5/QlikView/help-in-set-analysis/m-p/912144#M316534 <HTML><HEAD></HEAD><BODY><P>do you have master calendar?</P><P></P><P>If yes why don't you try with Max(Date)?</P></BODY></HTML> Wed, 05 Aug 2015 12:13:54 GMT https://community.qlik.com/t5/QlikView/help-in-set-analysis/m-p/912144#M316534 Anonymous 2015-08-05T12:13:54Z Re: help in set analysis https://community.qlik.com/t5/QlikView/help-in-set-analysis/m-p/912145#M316535 <HTML><HEAD></HEAD><BODY><P>yeah </P><P>I forgot about this function</P></BODY></HTML> Wed, 05 Aug 2015 12:16:47 GMT https://community.qlik.com/t5/QlikView/help-in-set-analysis/m-p/912145#M316535 ali_hijazi 2015-08-05T12:16:47Z