I have a dashboard to identify users who repeat their passport number to be able to detect if a passport number has different display name.
In a pivot chart I managed to differentiate a list only with those users using a calculated dimension = aggr (if (count (DISTINCT [Display Name])> = 2, [Passport Number]), [Passport Number]) it Works.
hi @sunny_talwar I just detected that there may be repeated users who are the same person (but for data cleasing issues..) they have different first name and last name. (the repeated user seems to have added their middle name and second last name). How can I create a validation for when these cases happen?
Maybe something in the script?
Maybe something like this thread: https://community.qlik.com/t5/QlikView-App-Development/First-Name-Last-Name/td-p/1325126 but im not sure.
is something I have not done before, but I would like to separate the first text string from the "First name" field and the first text string from the "Last name" field as a new field, so that I can display the "Display name" in the dashboard " to review
@sunny_talwar I solved it by means of a work around, I tried to split the fields "First Name" and "Last Name", and from that result I concatened them to be able to have an alternative value of "Display Name"
upper (SubField ([First Name], '', 1)) & '' & upper (SubField ([First Name], '', 0)) as NewName,
upper (SubField ([Last Name], '', 1)) & '' & upper (SubField ([Last Name], '', 0)) as NewLastName,
upper (SubField ([First Name], '', 1)) & '' & upper (SubField ([First Name], '', 0)) & Upper (SubField ([Last Name], '', 1)) & '' & Upper (SubField ([Last Name], '', 0)) as NewDisplayName
I feel that it is not the most optimal solution, but it allows me to calculate the KPI:
Expression: count (DISTINCT [Display Name])
Note: Everything that is> 2 then is what I need to have differentiated to review it