Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

num() function performance

Hi all

i have a field that sometimes has % values and sometimes has decimal values

i used this expression but it eats up performance

=if(MaxString({$<NAME_={'$(vSelectedName)'}>} IUnits) = '%',

num($(vTest),'#,##0.00%'),

num($(vTest),'#,##0.00'))

is there another way to write this with better performance?

Thanks

J

Labels (1)
0 Replies