topic Re: Variable value to number format in QlikView

Variable value to number format

madhuqliklondon — Sat, 16 Nov 2024 18:13:02 GMT

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.

Re: Variable value to number format

Fran_by — Tue, 18 Aug 2020 12:48:26 GMT

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

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

Re: Variable value to number format

madhuqliklondon — Tue, 18 Aug 2020 12:57:30 GMT

Thank you, this works for me.