https://community.qlik.com/t5/QlikView/Load-max-date-and-hour/m-p/1644513#M731477 <P>Duplicate post, see&nbsp;<A href="https://community.qlik.com/t5/QlikView-App-Development/Load-max-date-and-hour/td-p/1644389" target="_blank">https://community.qlik.com/t5/QlikView-App-Development/Load-max-date-and-hour/td-p/1644389</A>&nbsp;for live thread.</P> <P>Regards,<BR />Brett</P> Thu, 07 Nov 2019 21:58:37 GMT Brett_Bleess 2019-11-07T21:58:37Z https://community.qlik.com/t5/QlikView/Load-max-date-and-hour/m-p/1644384#M731476 <P>Hi All,</P><P>I have a table like this</P><TABLE><TBODY><TR><TD>Country</TD><TD>Date&nbsp;</TD><TD>Hour</TD><TD>Sales</TD></TR><TR><TD>germany</TD><TD>11/7/2019</TD><TD>1</TD><TD>100</TD></TR><TR><TD>germany</TD><TD>11/7/2019</TD><TD>2</TD><TD>101</TD></TR><TR><TD>germany</TD><TD>11/7/2019</TD><TD>3</TD><TD>102</TD></TR><TR><TD>germany</TD><TD>11/7/2019</TD><TD>4</TD><TD>103</TD></TR><TR><TD>Italy</TD><TD>11/7/2019</TD><TD>1</TD><TD>103</TD></TR><TR><TD>Italy</TD><TD>11/7/2019</TD><TD>2</TD><TD>104</TD></TR><TR><TD>Italy</TD><TD>11/8/2019</TD><TD>3</TD><TD>105</TD></TR><TR><TD>Spain</TD><TD>11/7/2019</TD><TD>1</TD><TD>106</TD></TR><TR><TD>Spain</TD><TD>11/7/2019</TD><TD>2</TD><TD>107</TD></TR><TR><TD>Spain</TD><TD>11/8/2019</TD><TD>3</TD><TD>108</TD></TR></TBODY></TABLE><P>Requirement is i want to get max date max hour sales for each country. So the output should be:</P><TABLE><TBODY><TR><TD>Country</TD><TD>Date&nbsp;</TD><TD>Hour</TD><TD>Sales</TD></TR><TR><TD>germany</TD><TD>11/7/2019</TD><TD>4</TD><TD>103</TD></TR><TR><TD>Italy</TD><TD>11/8/2019</TD><TD>3</TD><TD>105</TD></TR><TR><TD>Spain</TD><TD>11/8/2019</TD><TD>3</TD><TD>108</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>How to write a set expression for this?</P> Sat, 16 Nov 2024 02:00:28 GMT https://community.qlik.com/t5/QlikView/Load-max-date-and-hour/m-p/1644384#M731476 sanjujeeboy 2024-11-16T02:00:28Z https://community.qlik.com/t5/QlikView/Load-max-date-and-hour/m-p/1644513#M731477 <P>Duplicate post, see&nbsp;<A href="https://community.qlik.com/t5/QlikView-App-Development/Load-max-date-and-hour/td-p/1644389" target="_blank">https://community.qlik.com/t5/QlikView-App-Development/Load-max-date-and-hour/td-p/1644389</A>&nbsp;for live thread.</P> <P>Regards,<BR />Brett</P> Thu, 07 Nov 2019 21:58:37 GMT https://community.qlik.com/t5/QlikView/Load-max-date-and-hour/m-p/1644513#M731477 Brett_Bleess 2019-11-07T21:58:37Z