topic Max value for dimension - ignore nulls in QlikView https://community.qlik.com/t5/QlikView/Max-value-for-dimension-ignore-nulls/m-p/880785#M657693 <HTML><HEAD></HEAD><BODY><P>How can i find what the maximum date for a certain dimension is in the attached data is, ignoring nulls.</P><P></P><P>i.e. i need to know the most recent date for each market when there was revenue</P><P></P><P>Is it possible to do this in chart rather than in the load?</P></BODY></HTML> Mon, 18 May 2015 14:30:37 GMT 2015-05-18T14:30:37Z Max value for dimension - ignore nulls https://community.qlik.com/t5/QlikView/Max-value-for-dimension-ignore-nulls/m-p/880785#M657693 <HTML><HEAD></HEAD><BODY><P>How can i find what the maximum date for a certain dimension is in the attached data is, ignoring nulls.</P><P></P><P>i.e. i need to know the most recent date for each market when there was revenue</P><P></P><P>Is it possible to do this in chart rather than in the load?</P></BODY></HTML> Mon, 18 May 2015 14:30:37 GMT https://community.qlik.com/t5/QlikView/Max-value-for-dimension-ignore-nulls/m-p/880785#M657693 2015-05-18T14:30:37Z Re: Max value for dimension - ignore nulls https://community.qlik.com/t5/QlikView/Max-value-for-dimension-ignore-nulls/m-p/880786#M657694 <HTML><HEAD></HEAD><BODY><P>You can use the firstsortedvalue for this. See attached qvw.</P></BODY></HTML> Mon, 18 May 2015 14:41:20 GMT https://community.qlik.com/t5/QlikView/Max-value-for-dimension-ignore-nulls/m-p/880786#M657694 Gysbert_Wassenaar 2015-05-18T14:41:20Z Re: Max value for dimension - ignore nulls https://community.qlik.com/t5/QlikView/Max-value-for-dimension-ignore-nulls/m-p/880787#M657695 <HTML><HEAD></HEAD><BODY><P>This might help you</P></BODY></HTML> Mon, 18 May 2015 14:49:39 GMT https://community.qlik.com/t5/QlikView/Max-value-for-dimension-ignore-nulls/m-p/880787#M657695 jsanchezh 2015-05-18T14:49:39Z Re: Max value for dimension - ignore nulls https://community.qlik.com/t5/QlikView/Max-value-for-dimension-ignore-nulls/m-p/880788#M657696 <HTML><HEAD></HEAD><BODY><P>That worked Gysbert thanks!</P><P></P><P>What if I want to only show those markets where the date was more than 3 months ago?</P></BODY></HTML> Mon, 18 May 2015 14:56:56 GMT https://community.qlik.com/t5/QlikView/Max-value-for-dimension-ignore-nulls/m-p/880788#M657696 2015-05-18T14:56:56Z