Discussion Board for collaboration regarding Qlik DataMarket.
Is there a way to round all numbers in Millions to #,#0.00M by setting it up in Load Script?
I know I could do it in expressions by dividing my numbers by 1,000,000 and assign a format of '#,##0.00M'.
I am wondering can I do this in the script for all numbers so I don't have to repeat actions above in all expressions.
Yes you can.
Here is an example:
num(Sum(TotalRevenue), '#,#0.00M') AS 'Millions'
FROM [<your source>] (qvd)
Year(Date([DateKey])) = 2017;
Really just focus on the num statement.
Hope this helps.
Thank you for response. I am wondering if there is a way that I can round any numbers together without indicating the column names (TotalRevenue in your example)?
No you cannot