Discussion Board for collaboration on QlikView Scripting.
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.