Variable value to number format

[madhuqliklondon]

Hi all,

I am creating a variable as LET vMaxRowCount  = POW(2,20) which gives 1048576 max number rows in excel. , I am using the variable in a table to restrict max number rows to display and in the error message, I am applying the variable to display a message to make a selection to reduce rows less than VMaxRowCount which displays 1048576. how do I change this to number format like 1,048,576? is that possible to convert the variable value to number format? 

Thank you in advance.

[Fran_by · Accepted solution]

=num(vMaxRowCount , '#,##0',  '.'  ,  ',' )

more here:
https://community.qlik.com/t5/QlikView-Deployment/Number-Format-Text-Object/m-p/282885

[madhuqliklondon]

Thank you, this works for me.