4 Replies Latest reply: Jan 25, 2017 3:10 PM by Ricardo Henrique Silva Calheiros RSS

    I need to clean one column so the Qlik Sense so it shows only valid data

    Ricardo Henrique Silva Calheiros

      Hi my friends

      In my table i have one field called PLACA, this field have a format of character and should be filled as follows: AAA0123 (it´s just one exemplo)

      However some users fill with garbage, "aaaaaaa", "/ \ / \", "! @ # $%" and others ...
      I need to apply to this column in Qlik Sense a function that initially only displays fields that contain 7 characters.

      How to make this?