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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Sam_1985
Contributor II
Contributor II

Garbage Codes

Create a variable named UCOD, which will store the ICD codes for the UCOD according to the following logic:

  • Read the ICD code where ICD-TYPE = 'P'.

    • If the code is not found in the attached list of illogical (garbage) codes, it will be selected as the primary COD and stored in UCOD.

    • If the code is found in the garbage list, the system will then search for ICD codes where ICD-TYPE = 'O'.

      • If an ICD code of type O is not found in the garbage list, it will be selected as the primary COD and stored in UCOD.

      • If it is also found in the garbage list, the system will revert back to the ICD of type P and select it, even if it exists in the garbage list.

▶️ This part has already been implemented:

A second variable named Garbage Codes (Y/N) is created, which reads data from UCOD.

  • If the ICD code exists in the garbage list, it is marked as Y.

  • If it does not exist, it is marked as N.

 

Labels (1)
0 Replies