topic The last status in QlikView https://community.qlik.com/t5/QlikView/The-last-status/m-p/1069276#M929486 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN lang="EN-US" style="color: black; font-family: 'Calibri',sans-serif; font-size: 11pt; mso-ansi-language: EN-US;">Hi there,</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN lang="EN-US" style="color: black; font-family: 'Calibri',sans-serif; font-size: 11pt; mso-ansi-language: EN-US;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN lang="EN-US" style="color: black; font-family: 'Calibri',sans-serif; font-size: 11pt; mso-ansi-language: EN-US;">I have charged the following information.</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN lang="EN-US" style="color: black; font-family: 'Calibri',sans-serif; font-size: 11pt; mso-ansi-language: EN-US;">&nbsp;&nbsp; </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 354px;"><TBODY><TR><TD height="20" style="border: 0px black; border-image: none;" width="118"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">WAREHOUSE</SPAN></TD><TD style="border: 0px black; border-image: none;" width="118"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">DATE</SPAN></TD><TD style="border: 0px black; border-image: none;" width="118"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">STATUS</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">A</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">01/01/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">ON LINE</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">B</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">02/01/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">ON LINE</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">B</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">01/01/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">OFF LINE</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">C</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">02/01/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">OFF LINE</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">D</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">03/01/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">OFF LINE</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">D</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">02/01/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">OFF LINE</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">D</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">01/01/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">ON LINE</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">E</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">03/01/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">ON LINE</SPAN></TD></TR></TBODY></TABLE><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P><SPAN lang="EN-US" style="color: black; font-family: 'Calibri',sans-serif; font-size: 11pt; mso-ansi-language: EN-US;">As I can get a table where I said the last date for store their audit and status ..</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z The last status https://community.qlik.com/t5/QlikView/The-last-status/m-p/1069276#M929486 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN lang="EN-US" style="color: black; font-family: 'Calibri',sans-serif; font-size: 11pt; mso-ansi-language: EN-US;">Hi there,</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN lang="EN-US" style="color: black; font-family: 'Calibri',sans-serif; font-size: 11pt; mso-ansi-language: EN-US;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN lang="EN-US" style="color: black; font-family: 'Calibri',sans-serif; font-size: 11pt; mso-ansi-language: EN-US;">I have charged the following information.</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN lang="EN-US" style="color: black; font-family: 'Calibri',sans-serif; font-size: 11pt; mso-ansi-language: EN-US;">&nbsp;&nbsp; </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 354px;"><TBODY><TR><TD height="20" style="border: 0px black; border-image: none;" width="118"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">WAREHOUSE</SPAN></TD><TD style="border: 0px black; border-image: none;" width="118"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">DATE</SPAN></TD><TD style="border: 0px black; border-image: none;" width="118"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">STATUS</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">A</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">01/01/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">ON LINE</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">B</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">02/01/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">ON LINE</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">B</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">01/01/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">OFF LINE</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">C</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">02/01/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">OFF LINE</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">D</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">03/01/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">OFF LINE</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">D</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">02/01/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">OFF LINE</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">D</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">01/01/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">ON LINE</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">E</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">03/01/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">ON LINE</SPAN></TD></TR></TBODY></TABLE><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P><SPAN lang="EN-US" style="color: black; font-family: 'Calibri',sans-serif; font-size: 11pt; mso-ansi-language: EN-US;">As I can get a table where I said the last date for store their audit and status ..</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/The-last-status/m-p/1069276#M929486 2020-11-25T16:16:04Z Re: The last status https://community.qlik.com/t5/QlikView/The-last-status/m-p/1069277#M929487 <HTML><HEAD></HEAD><BODY><P>Store as Dimension and</P><P>MAX(DATE) and FirstSortedValue(STATUS,-DATE) as expressions</P></BODY></HTML> Mon, 14 Mar 2016 18:02:08 GMT https://community.qlik.com/t5/QlikView/The-last-status/m-p/1069277#M929487 Clever_Anjos 2016-03-14T18:02:08Z Re: The last status https://community.qlik.com/t5/QlikView/The-last-status/m-p/1069278#M929488 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P>Dimension: <STRONG>WAREHOUSE</STRONG></P><P></P><P>Expressions:</P><P>1) <STRONG>Date(Max(DATE))</STRONG></P><P>2) <STRONG>FirstSortedValue(STATUS, -DATE)</STRONG></P></BODY></HTML> Mon, 14 Mar 2016 18:02:44 GMT https://community.qlik.com/t5/QlikView/The-last-status/m-p/1069278#M929488 sunny_talwar 2016-03-14T18:02:44Z