0 Replies Latest reply: Mar 15, 2017 5:09 AM by Jenny Smith RSS

    Variable rounding to 2 decimal points

    Jenny Smith

      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;