Discussion board where members can learn more about Qlik Sense App Development and Usage.
would like to transform the following numeric 1 decimal values to money within the script?
Please can I ask how I might do this?
I suggest to let is as it is (numeric) and format it as money on the front-end on the properties on the object
Thanks, I would like the selection bar to show the finale money values and not an expression however, and so would like to transform within the script and not the front end.
I notice money() creates the desired output when using within an object, but not when applying to the script.
For anyone interested in doing the same, this solution seemed to work.
For i = 0 to 10
Let dec = $(i)*0.1;
Min_Price:LOAD MONEY(NUM(RecNo()-$(dec)),'$#######.#0') AS "Min Price", NUM(RecNo()-$(dec)) AS "Min Price Num"AutoGenerate(1000000);
Max_Price:LOAD MONEY(NUM(RecNo()-$(dec)),'$#######.#0') AS "Max Price", NUM(RecNo()-$(dec)) AS "Max Price Num"AutoGenerate(1000000);