7 Replies Latest reply: Oct 8, 2015 10:47 AM by Giacinto Abbruzzese RSS

    data validation script commands

    Giacinto Abbruzzese

      Hello,

       

      i'm still rather new to qlik sense. So my question(s) for the attached spreadsheet is the following:

       

      data validation digits.JPG

       

      We want to establish a data validation app that validates our input data (mostly excel-sheets) according to the rules we set.

      For example, one rule says that a certain field (column) shall only have cell-data with 7 digits (like customer ID's). With the data validation app we want to identify inconsistent data entries (e.g. having a customer ID with 8 digits).

      I'm simply looking for the correct syntax or script command to realise this request.