Yeah the data is actually stores in the risk assessment module and the checklists completed in our audits & inspections module. Would I need our supplier developers to link the two fields together somehow in order to be able to successfully compare the 2? Both datasets are free text boxes with validation rules on to prevent spaces or special characters being used.
No, the tables don't need to be joined. I was asking to see if there might be something else causing the expression to not return values. Attached is a qvf with the tables loaded via an inline script and the expression returning the appropriate values.
I can't open the attached file. We only have a diluted version of Qlik as embedded into one of our supplier systems so we can't do anything other than write scrip using the expression editor functionality.