https://community.qlik.com/t5/QlikView/calculated-dimension-using-max-date-per-constant-string/m-p/1532195#M438838 <P>I need the output with respect to the constant_string and date and I need both the values as they are distinct.</P> Fri, 18 Jan 2019 14:39:17 GMT wiz_nerd 2019-01-18T14:39:17Z https://community.qlik.com/t5/QlikView/calculated-dimension-using-max-date-per-constant-string/m-p/1532157#M438833 <P>I am trying to create a calculated dimension in which I need to consider (<U>distinct max</U><SPAN>&nbsp;</SPAN>date and<SPAN>&nbsp;</SPAN><U>distinct</U><SPAN>&nbsp;</SPAN>Name_String)&nbsp; to conclude <SPAN>output_string</SPAN>? Note Date is in RFC format</P><TABLE><TBODY><TR><TD>Name_String</TD><TD>date</TD><TD>output_string</TD></TR><TR><TD>string1</TD><TD>date1</TD><TD>string1_yyw3</TD></TR><TR><TD>string1</TD><TD>date3</TD><TD>string1_yyw2</TD></TR><TR><TD><FONT color="#999999">string1</FONT></TD><TD><FONT color="#999999">date3</FONT></TD><TD><FONT color="#3366FF">string1_yyw1</FONT></TD></TR><TR><TD>string2</TD><TD>date1</TD><TD>string2_yyw1</TD></TR><TR><TD>string2</TD><TD>date3</TD><TD>string2_yyw2</TD></TR><TR><TD><FONT color="#999999">string2</FONT></TD><TD><FONT color="#999999">date3</FONT></TD><TD><FONT color="#3366FF">string2_yyw3</FONT></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Output:</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><FONT color="#999999">string1</FONT></TD><TD><FONT color="#999999">date3</FONT></TD><TD><FONT color="#3366FF">string1_yyw1</FONT></TD></TR></TBODY></TABLE><TABLE><TBODY><TR><TD><FONT color="#999999">string2</FONT></TD><TD><FONT color="#999999">date3</FONT></TD><TD><FONT color="#3366FF">string2_yyw3</FONT></TD></TR></TBODY></TABLE> Sat, 16 Nov 2024 04:43:05 GMT https://community.qlik.com/t5/QlikView/calculated-dimension-using-max-date-per-constant-string/m-p/1532157#M438833 wiz_nerd 2024-11-16T04:43:05Z https://community.qlik.com/t5/QlikView/calculated-dimension-using-max-date-per-constant-string/m-p/1532191#M438837 why do you need string1_yyw1 rather than string1_yyw2 as output for string1 ?<BR />what does the logic behind it is ? Fri, 18 Jan 2019 14:35:11 GMT https://community.qlik.com/t5/QlikView/calculated-dimension-using-max-date-per-constant-string/m-p/1532191#M438837 agigliotti 2019-01-18T14:35:11Z https://community.qlik.com/t5/QlikView/calculated-dimension-using-max-date-per-constant-string/m-p/1532195#M438838 <P>I need the output with respect to the constant_string and date and I need both the values as they are distinct.</P> Fri, 18 Jan 2019 14:39:17 GMT https://community.qlik.com/t5/QlikView/calculated-dimension-using-max-date-per-constant-string/m-p/1532195#M438838 wiz_nerd 2019-01-18T14:39:17Z