topic Re: Dividing two variables produce wrong results in App Development https://community.qlik.com/t5/App-Development/Dividing-two-variables-produce-wrong-results/m-p/1331666#M29065 <HTML><HEAD></HEAD><BODY><P>None of the answers worked. Infact its a Qlik Sense issue instead of Qlik View. So I post it here.</P></BODY></HTML> Thu, 27 Apr 2017 13:21:24 GMT madnanansari 2017-04-27T13:21:24Z Dividing two variables produce wrong results https://community.qlik.com/t5/App-Development/Dividing-two-variables-produce-wrong-results/m-p/1331663#M29062 <HTML><HEAD></HEAD><BODY><P>I have defined the below variables in the system:</P><P></P><P>vSales1</P><P>vSales2</P><P>vTickets1</P><P>vTickets2</P><P></P><P>vSales = $(vSales1) + $(vSales2)</P><P></P><P>vTickets = $(vTickets1) + $(vTickets2)</P><P></P><P>AverageSales = ($(vSales1) + $(vSales2)) / ($(vTickets1)+$(vTickets2)) bring rights results.</P><P></P><P>where as the below formula brings wrong results:</P><P>AverageSales = $(vSales) / $(vTickets)</P><P></P><P>any idea how to resolve this?</P></BODY></HTML> Thu, 27 Apr 2017 12:55:10 GMT https://community.qlik.com/t5/App-Development/Dividing-two-variables-produce-wrong-results/m-p/1331663#M29062 madnanansari 2017-04-27T12:55:10Z Re: Dividing two variables produce wrong results https://community.qlik.com/t5/App-Development/Dividing-two-variables-produce-wrong-results/m-p/1331664#M29063 <HTML><HEAD></HEAD><BODY><P>Hi Mohammad,</P><P>Have you tried <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">AverageSales = ($(vSales)) / ($(vTickets))</SPAN>?</P><P>Regards,</P><P>H</P></BODY></HTML> Thu, 27 Apr 2017 12:59:02 GMT https://community.qlik.com/t5/App-Development/Dividing-two-variables-produce-wrong-results/m-p/1331664#M29063 hector_munoz 2017-04-27T12:59:02Z Re: Dividing two variables produce wrong results https://community.qlik.com/t5/App-Development/Dividing-two-variables-produce-wrong-results/m-p/1331665#M29064 <HTML><HEAD></HEAD><BODY><P>Didn't you get your answer here?</P><P><A href="https://community.qlik.com/thread/258509">Dividing variables bring wrong values</A></P></BODY></HTML> Thu, 27 Apr 2017 13:09:57 GMT https://community.qlik.com/t5/App-Development/Dividing-two-variables-produce-wrong-results/m-p/1331665#M29064 sunny_talwar 2017-04-27T13:09:57Z Re: Dividing two variables produce wrong results https://community.qlik.com/t5/App-Development/Dividing-two-variables-produce-wrong-results/m-p/1331666#M29065 <HTML><HEAD></HEAD><BODY><P>None of the answers worked. Infact its a Qlik Sense issue instead of Qlik View. So I post it here.</P></BODY></HTML> Thu, 27 Apr 2017 13:21:24 GMT https://community.qlik.com/t5/App-Development/Dividing-two-variables-produce-wrong-results/m-p/1331666#M29065 madnanansari 2017-04-27T13:21:24Z Re: Dividing two variables produce wrong results https://community.qlik.com/t5/App-Development/Dividing-two-variables-produce-wrong-results/m-p/1331667#M29066 <HTML><HEAD></HEAD><BODY><P>this brings wrong results</P></BODY></HTML> Thu, 27 Apr 2017 13:29:23 GMT https://community.qlik.com/t5/App-Development/Dividing-two-variables-produce-wrong-results/m-p/1331667#M29066 madnanansari 2017-04-27T13:29:23Z