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

    Convert concatenated numbers to num

    Tim Driller

      Hello,

       

      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

      Tim