topic Re: Set Analysis ? in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1437710#M431737 <HTML><HEAD></HEAD><BODY><P>Got it....had to remove FISYR</P></BODY></HTML> Wed, 08 Nov 2017 12:49:04 GMT tmumaw 2017-11-08T12:49:04Z Set Analysis ? https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1437709#M431736 <HTML><HEAD></HEAD><BODY><P>I am trying to calculate a percentage based on the year the user selected to current.&nbsp; I know I am missing something just not sure what.</P><P>Thanks</P><P>The first line is my current year and the other 2 are suppose to be based on the FISYR the user selects.</P><P></P><P><SPAN style="font-size: 12pt;">(</SPAN><SPAN style="font-size: 12pt;"><SPAN style="color: #0000ff;">sum</SPAN>({&lt;<SPAN style="color: #800000;">FISYR</SPAN> = {<STRONG><EM style=": ; color: #808080;">$(=$(vFisYr) - 0)</EM></STRONG>},<SPAN style="color: #800000;">[Expense]</SPAN> = {'E'},<SPAN style="color: #800000;">YTDFlag</SPAN> = {1}&gt;}<SPAN style="color: #800000;">[In company code currency_HSL]</SPAN>&nbsp; * 1) -<BR /> <SPAN style="color: #0000ff;">sum</SPAN>({$&lt;<SPAN style="color: #800000;">FISYR</SPAN>,<SPAN style="color: #800000;">[Expense]</SPAN> = {'E'},<SPAN style="color: #800000;">YTDFlag</SPAN> = {1}&gt;}<SPAN style="color: #800000;">[In company code currency_HSL]</SPAN>&nbsp; * 1)) /<BR /> <SPAN style="color: #0000ff;">sum</SPAN>({$&lt;<SPAN style="color: #800000;">FISYR</SPAN>,<SPAN style="color: #800000;">[Expense]</SPAN> = {'E'},<SPAN style="color: #800000;">YTDFlag</SPAN> = {1}&gt;}<SPAN style="color: #800000;">[In company code currency_HSL]</SPAN></SPAN><SPAN style="font-size: 12pt;">&nbsp; * 1) </SPAN></P></BODY></HTML> Wed, 08 Nov 2017 12:35:43 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1437709#M431736 tmumaw 2017-11-08T12:35:43Z Re: Set Analysis ? https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1437710#M431737 <HTML><HEAD></HEAD><BODY><P>Got it....had to remove FISYR</P></BODY></HTML> Wed, 08 Nov 2017 12:49:04 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1437710#M431737 tmumaw 2017-11-08T12:49:04Z