topic Variable Problem in QlikView https://community.qlik.com/t5/QlikView/Variable-Problem/m-p/965905#M331092 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a table with sales by month. My Budget is in Dollar I need to convert in Pesos. So I have a variable that take the dollar. The problem is with my formula Divide by all months And produce a distorsion in the final information. For Example. Dollar in January is 772.000 If I do clic in January the information is fine because just take the avg of January. But if I selecte Jan and Feb. January takes another mount, This is because is divide for the avg January and February. I Would Like to see the same information in both cases. The field is called valor_dolar. The Variable (Is the first variable in the list)</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 16 Sep 2015 15:35:24 GMT pgalvezt 2015-09-16T15:35:24Z Variable Problem https://community.qlik.com/t5/QlikView/Variable-Problem/m-p/965905#M331092 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a table with sales by month. My Budget is in Dollar I need to convert in Pesos. So I have a variable that take the dollar. The problem is with my formula Divide by all months And produce a distorsion in the final information. For Example. Dollar in January is 772.000 If I do clic in January the information is fine because just take the avg of January. But if I selecte Jan and Feb. January takes another mount, This is because is divide for the avg January and February. I Would Like to see the same information in both cases. The field is called valor_dolar. The Variable (Is the first variable in the list)</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 16 Sep 2015 15:35:24 GMT https://community.qlik.com/t5/QlikView/Variable-Problem/m-p/965905#M331092 pgalvezt 2015-09-16T15:35:24Z Re: Variable Problem https://community.qlik.com/t5/QlikView/Variable-Problem/m-p/965906#M331093 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Any Help,</P><P></P><P>Thanks!</P></BODY></HTML> Thu, 17 Sep 2015 14:29:51 GMT https://community.qlik.com/t5/QlikView/Variable-Problem/m-p/965906#M331093 pgalvezt 2015-09-17T14:29:51Z