Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
jennysmithrento
New Contributor

Variable rounding to 2 decimal points

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;

Community Browser