Please any one help on best solution to handle Error Validations in QlikView.
As we finished all development work but seriously stuck with validation mechanism if any one can help on my scenario.
We need to validate some key Columns whether it has Null values or Special Characters or white spaces.
when ever while loading data QlikView need to capture Errors in Key Columns and If It can show case as Error.I tried to logic in such a way if-else logic but i'm missing exactly,If any one has good solution please request to help on this.
Validations:
Office Column-->Blank Field Check
IssueKey Column-->Blank Field Check 4 characters or less Should only contain numbers or alphabets
Today started a Thread didn't get any right solution
Is QlikView ETL to Support Error Handling
I'm attaching sample data and qvw please provide valuable suggestions
