topic Re: Simple Set Analysis Question in QlikView https://community.qlik.com/t5/QlikView/Simple-Set-Analysis-Question/m-p/451833#M1154076 <HTML><HEAD></HEAD><BODY><P>Looks like that should work.&nbsp; </P><P></P><P>Do you have a sample data set you can pass on?</P></BODY></HTML> Mon, 18 Mar 2013 18:26:15 GMT 2013-03-18T18:26:15Z Simple Set Analysis Question https://community.qlik.com/t5/QlikView/Simple-Set-Analysis-Question/m-p/451832#M1154075 <HTML><HEAD></HEAD><BODY><P>I am trying to find the sum of all charges for the last date posted regardless of any selections.&nbsp; Currently I am working with this formula and striking out.&nbsp; Does anyone have any tips?</P><P></P><P>=<SPAN style="color: #0000ff; font-size: 8pt;">Sum</SPAN><SPAN style="font-size: 8pt;">({1&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Charges.POST_DATE]</SPAN><SPAN style="font-size: 8pt;">={</SPAN><STRONG style="color: #808080; font-size: 8pt;"><EM>$(=Max(Charges.POST_DATE))</EM></STRONG><SPAN style="font-size: 8pt;">}&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Charges.CHG_AMT]</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Thanks!</SPAN></P></BODY></HTML> Mon, 18 Mar 2013 18:14:40 GMT https://community.qlik.com/t5/QlikView/Simple-Set-Analysis-Question/m-p/451832#M1154075 2013-03-18T18:14:40Z Re: Simple Set Analysis Question https://community.qlik.com/t5/QlikView/Simple-Set-Analysis-Question/m-p/451833#M1154076 <HTML><HEAD></HEAD><BODY><P>Looks like that should work.&nbsp; </P><P></P><P>Do you have a sample data set you can pass on?</P></BODY></HTML> Mon, 18 Mar 2013 18:26:15 GMT https://community.qlik.com/t5/QlikView/Simple-Set-Analysis-Question/m-p/451833#M1154076 2013-03-18T18:26:15Z Re: Simple Set Analysis Question https://community.qlik.com/t5/QlikView/Simple-Set-Analysis-Question/m-p/451834#M1154077 <HTML><HEAD></HEAD><BODY><P>I added it to my original message</P><P></P><P>Thanks!</P></BODY></HTML> Mon, 18 Mar 2013 18:43:25 GMT https://community.qlik.com/t5/QlikView/Simple-Set-Analysis-Question/m-p/451834#M1154077 2013-03-18T18:43:25Z Re: Simple Set Analysis Question https://community.qlik.com/t5/QlikView/Simple-Set-Analysis-Question/m-p/451835#M1154080 <HTML><HEAD></HEAD><BODY><P>Oh sorry I didn't see it at first.</P><P></P><P>Looks like the set statement for POST_DATE doesn't recognized the date value properly so I forced the value with the following statement.</P><P></P><P>Sum({&lt;POST_DATE= {'$(=Date(MAX({1}POST_DATE),'YYYY-MM-DD'))'}&gt;}CHG_AMT) </P><P></P><P>Hope this helps.</P></BODY></HTML> Mon, 18 Mar 2013 19:51:40 GMT https://community.qlik.com/t5/QlikView/Simple-Set-Analysis-Question/m-p/451835#M1154080 2013-03-18T19:51:40Z Re: Simple Set Analysis Question https://community.qlik.com/t5/QlikView/Simple-Set-Analysis-Question/m-p/451836#M1154082 <HTML><HEAD></HEAD><BODY><P>No you didn't miss it, I added it after you asked for the data!</P><P></P><P>It worked perfectly!</P><P></P><P>THANK YOU SO MUCH!</P></BODY></HTML> Mon, 18 Mar 2013 19:54:16 GMT https://community.qlik.com/t5/QlikView/Simple-Set-Analysis-Question/m-p/451836#M1154082 2013-03-18T19:54:16Z