topic Re: Variable in QlikView https://community.qlik.com/t5/QlikView/Variable/m-p/521689#M194952 <HTML><HEAD></HEAD><BODY><P>can you share the test data with issue you faced.</P></BODY></HTML> Thu, 25 Jul 2013 04:25:49 GMT Kushal_Chawda 2013-07-25T04:25:49Z Variable https://community.qlik.com/t5/QlikView/Variable/m-p/521686#M194949 <HTML><HEAD></HEAD><BODY><P>Hi all I have a question on this table. I have a variable(name target) with a default value where user can change the value of the variable.</P><P></P><P>say the default value is 4000</P><P></P><P>it will use the target value of 4000 and deduct sales of 2000 to give a new range of 2000 this will carry on throughout the table</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Name</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Profit/(Loss)</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Target</STRONG></SPAN></TH></TR><TR><TD>Peter</TD><TD>2000</TD><TD>2000</TD></TR><TR><TD>Lim</TD><TD>200</TD><TD>1800</TD></TR><TR><TD>woob</TD><TD>(1300)</TD><TD>3100</TD></TR><TR><TD>haha</TD><TD>400</TD><TD>2700</TD></TR></TBODY></TABLE><P></P><P></P><P>Over in local drive, it will manage to calculate each of the single row and dislay on the target</P><P></P><P>however when i uploaded the report to the server, the target column actually calculated 20% of the full table?</P><P></P><P>Why is that so. there is alot of blanks on the target column at the end</P></BODY></HTML> Thu, 25 Jul 2013 00:24:11 GMT https://community.qlik.com/t5/QlikView/Variable/m-p/521686#M194949 n1ef5ng1 2013-07-25T00:24:11Z Re: Variable https://community.qlik.com/t5/QlikView/Variable/m-p/521687#M194950 <HTML><HEAD></HEAD><BODY><P>any solution&gt;</P></BODY></HTML> Thu, 25 Jul 2013 02:28:42 GMT https://community.qlik.com/t5/QlikView/Variable/m-p/521687#M194950 n1ef5ng1 2013-07-25T02:28:42Z Re: Variable https://community.qlik.com/t5/QlikView/Variable/m-p/521688#M194951 <HTML><HEAD></HEAD><BODY><P>Get back to you asap. I try find a solution</P></BODY></HTML> Thu, 25 Jul 2013 03:04:46 GMT https://community.qlik.com/t5/QlikView/Variable/m-p/521688#M194951 2013-07-25T03:04:46Z Re: Variable https://community.qlik.com/t5/QlikView/Variable/m-p/521689#M194952 <HTML><HEAD></HEAD><BODY><P>can you share the test data with issue you faced.</P></BODY></HTML> Thu, 25 Jul 2013 04:25:49 GMT https://community.qlik.com/t5/QlikView/Variable/m-p/521689#M194952 Kushal_Chawda 2013-07-25T04:25:49Z