6 Replies Latest reply: Apr 25, 2013 7:03 AM by Anushree Gore RSS

    How to use calculated column to calculate another column..??

      Q1: I am loading following columns in QV but it is showing Error as : Field Not Found :  Actual_Processed_Date

       

      LOAD

      SRID,       

         EnteredDate,

          ProcessedDate,

              if(Isnull(ProcessedDate),Today(),ProcessedDate) as Actual_Processed_Date,

      NETWORKDAYS( EnteredDate,IF(IsNull(Actual_Processed_Date)='False',Actual_Processed_Date,TODAY()),[Network Days]) as Network_Days

      FROM

      [\\pcg\root\users\anushree.gore\Desktop\L2-Data.xlsx

      ] (ooxml, embedded labels, table is [L2-Data]);

       

       

      Please Suggest a solution.. I want to use Actual_Processed_Date column for calcuting NetworkDays...

       

       

       

      Q2: Also is there any way in Qlikview to to round off the date? For eg My actual value is 2013-01-03 00:49:08.287 and I want ot round it off as 1/3/13 12:00 AM. This is possible in Excel using RoundDown function... How can we do it in qlikview?