topic Operations with variables in QlikView https://community.qlik.com/t5/QlikView/Operations-with-variables/m-p/229775#M81663 <HTML><HEAD></HEAD><BODY><P>The problem is exactly that:</P><P>If you enter multiple level ad parenthesis, the formula is not calculated.</P><P>If they want to keep multiple levels of parentheses, it is necessary to "wrap" (CR) at every level of brackets.</P><P>I think this is a bug !!!</P><P>Councils write to technical support?</P><P>Thanks. Adriano</P><P></P></BODY></HTML> Fri, 23 Jul 2010 10:49:37 GMT 2010-07-23T10:49:37Z Operations with variables https://community.qlik.com/t5/QlikView/Operations-with-variables/m-p/229766#M81654 <HTML><HEAD></HEAD><BODY><P>The problem is this: mathematical operations between variables do not work well !</P><P>This apparently ! In fact you must format the formula to get a correct result ( <STRONG>IS A BUG ???)</STRONG></P><P><STRONG>This not Work:</STRONG></P><P>=(<B>$(v_Saldo)</B> / <B>$(v_Saldo_ap_1_mobile)</B>)-1</P><P>This Work (!!!!)</P><P>=(</P><P><B>$(v_Saldo)</B> / <B>$(v_Saldo_ap_1_mobile)</B></P><P>)-1</P><P>Does anyone know?</P><P>Adriano</P></BODY></HTML> Wed, 21 Jul 2010 16:01:18 GMT https://community.qlik.com/t5/QlikView/Operations-with-variables/m-p/229766#M81654 2010-07-21T16:01:18Z Operations with variables https://community.qlik.com/t5/QlikView/Operations-with-variables/m-p/229767#M81655 <HTML><HEAD></HEAD><BODY><P>Both expressions works fine for me. I am using QlikView 9.0 SR4</P></BODY></HTML> Fri, 23 Jul 2010 07:46:48 GMT https://community.qlik.com/t5/QlikView/Operations-with-variables/m-p/229767#M81655 manishkumar75 2010-07-23T07:46:48Z Operations with variables https://community.qlik.com/t5/QlikView/Operations-with-variables/m-p/229768#M81656 <HTML><HEAD></HEAD><BODY><P>You should not need to do this.</P><P>What are the values in the variables when you try the expression?</P><P>Jonathan</P></BODY></HTML> Fri, 23 Jul 2010 08:23:28 GMT https://community.qlik.com/t5/QlikView/Operations-with-variables/m-p/229768#M81656 jonathandienst 2010-07-23T08:23:28Z AW:Re: Operations with variables https://community.qlik.com/t5/QlikView/Operations-with-variables/m-p/229769#M81657 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>maybe you have to use the variables without $(), if variables are numeric, their behaviour is like fields</P><P>=(<B>v_Saldo</B> / <B>v_Saldo_ap_1_mobile</B>)-1</P></BODY></HTML> Fri, 23 Jul 2010 08:37:52 GMT https://community.qlik.com/t5/QlikView/Operations-with-variables/m-p/229769#M81657 brenner_martina 2010-07-23T08:37:52Z AW:Re: Operations with variables https://community.qlik.com/t5/QlikView/Operations-with-variables/m-p/229770#M81658 <HTML><HEAD></HEAD><BODY><P>Hello.</P><P>Unfortunately the problem persists even without using variables $</P></BODY></HTML> Fri, 23 Jul 2010 09:58:50 GMT https://community.qlik.com/t5/QlikView/Operations-with-variables/m-p/229770#M81658 2010-07-23T09:58:50Z Operations with variables https://community.qlik.com/t5/QlikView/Operations-with-variables/m-p/229771#M81659 <HTML><HEAD></HEAD><BODY><P>Hi Jonathan</P><P>The values are:</P><P style="font-weight: bold"></P><P style="font-weight: bold">$(v_Saldo) = -7630554,26</P><P style="font-weight: bold"></P><P style="font-weight: bold">$(v_Saldo_ap_1_mobile) = -1242752,57</P><P style="font-weight: bold">Adriano</P><BR /><BR /> <P></P><BR /><BR /></BODY></HTML> Fri, 23 Jul 2010 10:03:27 GMT https://community.qlik.com/t5/QlikView/Operations-with-variables/m-p/229771#M81659 2010-07-23T10:03:27Z Operations with variables https://community.qlik.com/t5/QlikView/Operations-with-variables/m-p/229772#M81660 <HTML><HEAD></HEAD><BODY><P>I am using QlikView 9.0 SR5 (.....)</P></BODY></HTML> Fri, 23 Jul 2010 10:04:27 GMT https://community.qlik.com/t5/QlikView/Operations-with-variables/m-p/229772#M81660 2010-07-23T10:04:27Z Operations with variables https://community.qlik.com/t5/QlikView/Operations-with-variables/m-p/229773#M81661 <HTML><HEAD></HEAD><BODY><P>The macro expansion version doesn't work for me either (I don't know why), but the simple one</P><P style="font-weight: bold">(v_Saldo / v_Saldo_ap_1_mobile)-1</P><P>does. See the attached qvw.</P><P></P></BODY></HTML> Fri, 23 Jul 2010 10:30:27 GMT https://community.qlik.com/t5/QlikView/Operations-with-variables/m-p/229773#M81661 jonathandienst 2010-07-23T10:30:27Z Operations with variables https://community.qlik.com/t5/QlikView/Operations-with-variables/m-p/229774#M81662 <HTML><HEAD></HEAD><BODY><P>Forgot to say, I am also using SR5.</P></BODY></HTML> Fri, 23 Jul 2010 10:31:26 GMT https://community.qlik.com/t5/QlikView/Operations-with-variables/m-p/229774#M81662 jonathandienst 2010-07-23T10:31:26Z Operations with variables https://community.qlik.com/t5/QlikView/Operations-with-variables/m-p/229775#M81663 <HTML><HEAD></HEAD><BODY><P>The problem is exactly that:</P><P>If you enter multiple level ad parenthesis, the formula is not calculated.</P><P>If they want to keep multiple levels of parentheses, it is necessary to "wrap" (CR) at every level of brackets.</P><P>I think this is a bug !!!</P><P>Councils write to technical support?</P><P>Thanks. Adriano</P><P></P></BODY></HTML> Fri, 23 Jul 2010 10:49:37 GMT https://community.qlik.com/t5/QlikView/Operations-with-variables/m-p/229775#M81663 2010-07-23T10:49:37Z