Using Match to link orderwriter with credit person

[SDeLa131]

How to match the orderWriter, example CD, (include how many orders CD created for the selected day, with the Credit person = (CD) and how many Errors created for this day.

See image, the blue line, we would like to be in the orange line. 

Using a pivot table, (dimension) orderwriter_csr   This is selective user profiles. This is working correctly 

=if(match( [VCOHead_OrderWriter] ,'AL','AF','AS', 'CD','DF','EB','HS','KMK','MO','MS','MG','MJ','MF','RB','RC','SR','SW'),[VCOHead_CreditPerson_CSR])

OrdersEnteredLessErrors (Measure) works correctly, gives me the nu of orders the person put in for the date select. 

OrderHeader_CreditReason -(dimension)  is pulling in the right person for this selective day 

OrdersEntered_CSR (dimension) is also correct - CD entered one order incorrect for this invoice date. 

Would like to see its show across. User CD. 

any ideas by chance. 

[BPiotrowski]

Hi @SDeLa131 

So from the ss I can say your data is not connected correctly.

I would check load script first,

it looks like youve concatenated 2 tables without VCOHead_CreditPerson_CSR

Example:

TableA:          TableB:            Concatenated:

a, b                 b, c                 a, b, c
A, 1      +        1, x        =>     A, 1, -
B, 2                2, y                 B, 2, -
                                             -, 1, x
                                             -, 2, y

Without seeing load script its first shot.

First Example:
https://help.qlik.com/en-US/sense/May2025/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes/...

Look for left join or mapping load first and map fields when you load main data by first dimension.

[SDeLa131]

This is a single file vcohead, which has a unique key that is the order number but the person who wrote the order and the person who created the error is two different people. Two different fields in the same file.