topic Re: Need help with the Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Need-help-with-the-Set-Analysis/m-p/141328#M602172 <HTML><HEAD></HEAD><BODY><P>Would you be able to share a sample or image of the problem chart? It would be good to see what you are getting and what you are looking to get</P></BODY></HTML> Tue, 09 Oct 2018 15:41:00 GMT sunny_talwar 2018-10-09T15:41:00Z Need help with the Set Analysis https://community.qlik.com/t5/QlikView/Need-help-with-the-Set-Analysis/m-p/141327#M602171 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am trying to resolve an issue with the Set analysis but not able to do so.</P><P></P><P> <SPAN class="left" style="font-size: 10pt; color: #000000;">sum({$&lt;Date={"&gt;=$(=$(Var12months))&lt;=$(=$(VarSelecteddate))"}, Filter={'*'}-{'UP'}&gt;}Amount)</SPAN> </P><P></P><P>This string is giving me a graph for last 11 month depending upon the date selected in the variables and data present in report, <SPAN style="font-size: 10pt;">but the graph is not working properly if i am selecting any other filter it gives Random data in the graph.</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">We have two columns on which we are applying filter one being the parent in the hierarchy so it has one to many mapping in the data model. but if i am writing this set analysis in a straight table i am getting many to many mapping for those two fields.</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Any suggestion on the same will be of great help..</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Thanks</SPAN></P><P><SPAN style="font-size: 10pt;">Arpit</SPAN></P><TABLE></TABLE></BODY></HTML> Tue, 09 Oct 2018 07:32:04 GMT https://community.qlik.com/t5/QlikView/Need-help-with-the-Set-Analysis/m-p/141327#M602171 arpit1508 2018-10-09T07:32:04Z Re: Need help with the Set Analysis https://community.qlik.com/t5/QlikView/Need-help-with-the-Set-Analysis/m-p/141328#M602172 <HTML><HEAD></HEAD><BODY><P>Would you be able to share a sample or image of the problem chart? It would be good to see what you are getting and what you are looking to get</P></BODY></HTML> Tue, 09 Oct 2018 15:41:00 GMT https://community.qlik.com/t5/QlikView/Need-help-with-the-Set-Analysis/m-p/141328#M602172 sunny_talwar 2018-10-09T15:41:00Z