8 Replies Latest reply: Apr 2, 2016 10:47 AM by Sunny Talwar RSS

    Help to create a total duration field

    Alisha Wadiwalla

      Hi all,

       

      I am new to Qlik software, currently, I am trying to create a total duration field by multiplying fields of 'duration' and 'frequency'. (Please see attached file, I would like to add this column to my table and I have tried to add a measure/dimension by writing the expression =Extension(call duration)*Call Skills (frequency) but it shows as nill...

       

      E.g. the first line would be 0:00:00 * 38 = 0:00:00, the second would be 0:00:01 * 51 = 0:00:51, etc

       

       

      I'm sure this is basic!, but i'd really appreciate your help!