Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
marko_rakar
Creator
Creator

Validating a field?

Hello,

I have a database with couple of hundreds of thousands fields which need to be validated as a part of the project.

The field in question is similar to US social security number and one of the numbers is control/check number calculated according to ISO7064 (mod 11,10).

Is it possible to do a check like that within qlikview?

2 Replies
Not applicable

It is possible to do validations in qlikview. Please post your query in detail...

marko_rakar
Creator
Creator
Author

Thanks,

here is a web page with a number of validation code snippets in different languages DomagojPa blog | Osobni identifikacijski broj – OIB

We are talking about validation national identification number, this is 11 numbers long, and last character is control number.

Any ideas (or pointers on how_to)? I appreciate any help.