https://community.qlik.com/t5/QlikView/Using-Variables-in-Straight-Table/m-p/201657#M59662 <HTML><HEAD></HEAD><BODY><P>Hi folks,<BR />i have the enclosed straight table, each ratio(row) calculated by s varibale (i have around 100 ratio)</P><P>Ratio Expression</P><P>A VarA</P><P>B VarB</P><P>C VarC</P><P>VarA= sum( {&lt;N={A}Month={'$(vMaxMonth)'}&gt;} V)<BR />VarB= sum( {&lt;N={B}&gt;} V)<BR />VarC= sum( {&lt;N={C}Month={'$(vMinMonth)'}&gt;} V)</P><P>i put the following expression $(VarA) works great but i have 100+ ratios ( i try to avoid using IF)</P><P>any ideas ?????</P><P></P></BODY></HTML> Wed, 15 Sep 2010 12:18:40 GMT 2010-09-15T12:18:40Z https://community.qlik.com/t5/QlikView/Using-Variables-in-Straight-Table/m-p/201657#M59662 <HTML><HEAD></HEAD><BODY><P>Hi folks,<BR />i have the enclosed straight table, each ratio(row) calculated by s varibale (i have around 100 ratio)</P><P>Ratio Expression</P><P>A VarA</P><P>B VarB</P><P>C VarC</P><P>VarA= sum( {&lt;N={A}Month={'$(vMaxMonth)'}&gt;} V)<BR />VarB= sum( {&lt;N={B}&gt;} V)<BR />VarC= sum( {&lt;N={C}Month={'$(vMinMonth)'}&gt;} V)</P><P>i put the following expression $(VarA) works great but i have 100+ ratios ( i try to avoid using IF)</P><P>any ideas ?????</P><P></P></BODY></HTML> Wed, 15 Sep 2010 12:18:40 GMT https://community.qlik.com/t5/QlikView/Using-Variables-in-Straight-Table/m-p/201657#M59662 2010-09-15T12:18:40Z