17 Replies Latest reply: Oct 19, 2016 1:03 PM by sonygot g RSS

    Convert concatenated numbers to num

    Tim Driller



      i want to generate a concatenated number out of the following fields.

      num(num(Store_ID, '0000')&num(BusinessDay, '000000')&num(cashier, '00')&num(Trans_ID, '0000')))


      QlikView doesnt Interpret this as a number.

      Is there a trick to get a number out of that?


      Thanks in advance for help