Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
=num(vMaxRowCount , '#,##0', '.' , ',' )
more here:
https://community.qlik.com/t5/QlikView-Deployment/Number-Format-Text-Object/m-p/282885
=num(vMaxRowCount , '#,##0', '.' , ',' )
more here:
https://community.qlik.com/t5/QlikView-Deployment/Number-Format-Text-Object/m-p/282885
Thank you, this works for me.