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






              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



      ] (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?