8 Replies Latest reply: Mar 20, 2018 3:19 PM by neha kumari RSS

    data validation script commands

    Giacinto Abbruzzese



      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.