Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Number of blanks and out of range per field

Hi,

I would like to create a table with the percentage of empty, out of ranges, and "Invalid format" records for all fields.

For example, on the the following table I would like to create a chart with the Dimension fields (just 2 values - Age and Children), and the value of the expresions should be:

- Empty = Age  20% // Children 20%

- Out of ranges = Age  20% (considering averything less than 10 and over 100) // Children 10% considering over 20

- Invalid format =  Age  10% (considering everyhing is not numeric) // Children 10% (considering everyhing is not numeric)

Thanks in advance.

  

EmployeeAgeChildren
Emp148
Emp2252
Emp3 3
Emp459 T
Emp5372
Emp6 2
Emp7223
Emp8£$55
Emp9482
Emp1019911
Community Browser