topic Re: How to select data last update (Expression)? in QlikView https://community.qlik.com/t5/QlikView/How-to-select-data-last-update-Expression/m-p/1421413#M428784 <HTML><HEAD></HEAD><BODY><P>PFA</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/187330_Capture.JPG" style="height: auto;" /></P></BODY></HTML> Mon, 18 Dec 2017 13:16:33 GMT Anil_Babu_Samineni 2017-12-18T13:16:33Z How to select data last update (Expression)? https://community.qlik.com/t5/QlikView/How-to-select-data-last-update-Expression/m-p/1421411#M428782 <HTML><HEAD></HEAD><BODY><P>If I have data as excel (attach file)</P><P></P><P>I need 2 results as below</P><P>1. Count member uniq by status</P><P></P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid #000000; width: 326px; height: 91px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Status</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Count Member Uniq (Last Quarter)</TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">2</TD></TR></TBODY></TABLE><P></P><P>2.summary sale by member but show last status (Q4)</P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 308px;"><TBODY><TR><TD class="xl66" height="17" style="text-align: center;" width="89"><SPAN style="color: #ff0000;">Member_Code</SPAN></TD><TD class="xl66" style="border-left: none; text-align: center;" width="89"><SPAN style="color: #ff0000;">Status (Q4)</SPAN></TD><TD class="xl66" style="border-left: none; text-align: center;" width="130"><SPAN style="color: #ff0000;">Sum Sale (Q1-Q4)</SPAN></TD></TR><TR><TD align="left" class="xl65" height="17" style="border-top: none;">100001</TD><TD class="xl68" style="border-top: none; border-left: none;">A</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">970</TD></TR><TR><TD align="left" class="xl65" height="17" style="border-top: none;">100002</TD><TD class="xl68" style="border-top: none; border-left: none;">A</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1,044</TD></TR><TR><TD align="left" class="xl65" height="17" style="border-top: none;">100003</TD><TD class="xl68" style="border-top: none; border-left: none;">C</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1,628</TD></TR><TR><TD align="left" class="xl65" height="17" style="border-top: none;">100004</TD><TD class="xl68" style="border-top: none; border-left: none;">C</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">897</TD></TR><TR><TD align="left" class="xl65" height="17" style="border-top: none;">100005</TD><TD class="xl68" style="border-top: none; border-left: none;">B</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">829</TD></TR><TR><TD align="left" class="xl65" height="17" style="border-top: none;">100006</TD><TD class="xl68" style="border-top: none; border-left: none;">A</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1,304</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 18 Dec 2017 12:50:07 GMT https://community.qlik.com/t5/QlikView/How-to-select-data-last-update-Expression/m-p/1421411#M428782 panwipa2528 2017-12-18T12:50:07Z Re: How to select data last update (Expression)? https://community.qlik.com/t5/QlikView/How-to-select-data-last-update-Expression/m-p/1421412#M428783 <HTML><HEAD></HEAD><BODY><P>First one may be using this?</P><P></P><P>Dimension is <STRONG>Status</STRONG></P><P>Expression</P><P><STRONG>Aggr(Count({&lt;Quarter = {$(=MaxString(Quarter))}&gt;} Member_Code), Status)</STRONG></P><P></P><P>May be for second one like below</P><P></P><P>Dimension is <STRONG>Member_Code</STRONG></P><P>And expressions are</P><P>1) <STRONG>FirstSortedValue({&lt;Quarter = {$(=MaxString(Quarter))}&gt;} Status, -Sale)</STRONG></P><P>2) <STRONG>Sum(Aggr(Sum(Sale), Member_Code))</STRONG></P></BODY></HTML> Mon, 18 Dec 2017 13:14:48 GMT https://community.qlik.com/t5/QlikView/How-to-select-data-last-update-Expression/m-p/1421412#M428783 Anil_Babu_Samineni 2017-12-18T13:14:48Z Re: How to select data last update (Expression)? https://community.qlik.com/t5/QlikView/How-to-select-data-last-update-Expression/m-p/1421413#M428784 <HTML><HEAD></HEAD><BODY><P>PFA</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/187330_Capture.JPG" style="height: auto;" /></P></BODY></HTML> Mon, 18 Dec 2017 13:16:33 GMT https://community.qlik.com/t5/QlikView/How-to-select-data-last-update-Expression/m-p/1421413#M428784 Anil_Babu_Samineni 2017-12-18T13:16:33Z