topic Re: Set Analysis with two functions in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-with-two-functions/m-p/533259#M481395 <HTML><HEAD></HEAD><BODY><P>It was the Date format. The date was displayed 2013-10-07 in list boxes etc but it was stored as 20131007.</P></BODY></HTML> Wed, 09 Oct 2013 14:40:15 GMT 2013-10-09T14:40:15Z Set Analysis with two functions https://community.qlik.com/t5/QlikView/Set-Analysis-with-two-functions/m-p/533257#M481393 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a Set Analysis where I want to only sum the values for the Max forecast submission. I have the expression below that doesnt work <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />. </P><P></P><P>=sum({&lt;ForecastDate={'$(=date(Max(ForecastDate)))'}&gt;} Volume)</P><P></P><P>I dont know how to write the expression to get it to sum for only the Maximum forecast Submission which is stored as ForecastDate. I dont mind if I have to use a variable to get it to work. I have tried that as well but cant get the Set Analysis to work there either. </P><P></P><P>I am happy for any help!</P><P></P><P>//Fredrik</P></BODY></HTML> Wed, 09 Oct 2013 12:46:11 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-two-functions/m-p/533257#M481393 2013-10-09T12:46:11Z Re: Set Analysis with two functions https://community.qlik.com/t5/QlikView/Set-Analysis-with-two-functions/m-p/533258#M481394 <HTML><HEAD></HEAD><BODY><P>You're expression looks correct. If it doesn't work that could be because you misspelled a field name, Qlikview is case-sensitive wrt field names. Or ForecastDate contains strings instead of numeric dates causing max to fail to get the max date. If you need more help post a sample document that demonstrates the issue.</P></BODY></HTML> Wed, 09 Oct 2013 13:23:51 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-two-functions/m-p/533258#M481394 Gysbert_Wassenaar 2013-10-09T13:23:51Z Re: Set Analysis with two functions https://community.qlik.com/t5/QlikView/Set-Analysis-with-two-functions/m-p/533259#M481395 <HTML><HEAD></HEAD><BODY><P>It was the Date format. The date was displayed 2013-10-07 in list boxes etc but it was stored as 20131007.</P></BODY></HTML> Wed, 09 Oct 2013 14:40:15 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-two-functions/m-p/533259#M481395 2013-10-09T14:40:15Z