topic num() function performance in QlikView https://community.qlik.com/t5/QlikView/num-function-performance/m-p/558559#M1140612 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P>i have a field that sometimes has % values and sometimes has decimal values</P><P>i used this expression but it eats up performance</P><P></P><P>=if(MaxString({$&lt;NAME_={'$(vSelectedName)'}&gt;} IUnits) = '%',</P><P>num($(vTest),'#,##0.00%'),</P><P>num($(vTest),'#,##0.00'))</P><P></P><P>is there another way to write this with better performance?</P><P></P><P>Thanks</P><P>J</P></BODY></HTML> Tue, 24 Sep 2013 11:51:02 GMT Anonymous 2013-09-24T11:51:02Z num() function performance https://community.qlik.com/t5/QlikView/num-function-performance/m-p/558559#M1140612 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P>i have a field that sometimes has % values and sometimes has decimal values</P><P>i used this expression but it eats up performance</P><P></P><P>=if(MaxString({$&lt;NAME_={'$(vSelectedName)'}&gt;} IUnits) = '%',</P><P>num($(vTest),'#,##0.00%'),</P><P>num($(vTest),'#,##0.00'))</P><P></P><P>is there another way to write this with better performance?</P><P></P><P>Thanks</P><P>J</P></BODY></HTML> Tue, 24 Sep 2013 11:51:02 GMT https://community.qlik.com/t5/QlikView/num-function-performance/m-p/558559#M1140612 Anonymous 2013-09-24T11:51:02Z