topic How to divide two variables? in QlikView https://community.qlik.com/t5/QlikView/How-to-divide-two-variables/m-p/274367#M582840 <HTML><HEAD></HEAD><BODY><P> Hi Alex: what is Cnt in your formula?</P></BODY></HTML> Tue, 25 Oct 2011 15:42:23 GMT 2011-10-25T15:42:23Z How to divide two variables? https://community.qlik.com/t5/QlikView/How-to-divide-two-variables/m-p/274366#M582839 <HTML><HEAD></HEAD><BODY><P>I want to divide to variables, this syntax is not working.</P><P></P><P>=Sum($(vSetYTD)Cnt/$(vSetPreviousYearYTD)Cnt))</P><P></P><P>Alex</P></BODY></HTML> Tue, 25 Oct 2011 15:35:20 GMT https://community.qlik.com/t5/QlikView/How-to-divide-two-variables/m-p/274366#M582839 2011-10-25T15:35:20Z How to divide two variables? https://community.qlik.com/t5/QlikView/How-to-divide-two-variables/m-p/274367#M582840 <HTML><HEAD></HEAD><BODY><P> Hi Alex: what is Cnt in your formula?</P></BODY></HTML> Tue, 25 Oct 2011 15:42:23 GMT https://community.qlik.com/t5/QlikView/How-to-divide-two-variables/m-p/274367#M582840 2011-10-25T15:42:23Z How to divide two variables? https://community.qlik.com/t5/QlikView/How-to-divide-two-variables/m-p/274368#M582841 <HTML><HEAD></HEAD><BODY><P>Its the column that I'm using. The parens where just in the wrong order. I needed to close the sum on the first expression. This works.</P><P></P><P></P><P>Sum($(vSetYTD)Cnt)-sum($(vSetPreviousYearYTD)Cnt)</P></BODY></HTML> Tue, 25 Oct 2011 15:50:15 GMT https://community.qlik.com/t5/QlikView/How-to-divide-two-variables/m-p/274368#M582841 2011-10-25T15:50:15Z How to divide two variables? https://community.qlik.com/t5/QlikView/How-to-divide-two-variables/m-p/274369#M582842 <HTML><HEAD></HEAD><BODY><P> Great...!</P></BODY></HTML> Tue, 25 Oct 2011 15:53:07 GMT https://community.qlik.com/t5/QlikView/How-to-divide-two-variables/m-p/274369#M582842 2011-10-25T15:53:07Z