Variable rounding to 2 decimal points

Anonymous — Wed, 15 Mar 2017 09:09:34 GMT

Hi all,

I have set up my script to pull through a range of variables from an excel file. Unfortunately, qlik seems to be rounding these variables to 2 decimal points but I need them to at least 3.

Does anyone know how to change this format?

See below for my script to load in variables:

Temp_Variables:

LOAD Name,

VarValue

FROM

P:\Rentokil Pest Control\D99 Management\Pricing and Margin Analysis\Z. Qlikview models\Hygiene\Mapping data\Variables.xlsx

(ooxml, embedded labels, table is Sheet1);

// Create variables

for i = 0 to NoOfRows('Temp_Variables') - 1

let vName = peek('Name', i, 'Temp_Variables'); // Name of the variable

let $(vName) = peek('VarValue', i, 'Temp_Variables'); // Expression

next i

// Remove temp variables

let i = null();

let vName = null();

// Remove temp tables

drop table Temp_Variables;

topic Variable rounding to 2 decimal points in QlikView

Variable rounding to 2 decimal points