Help! Comparing values in different fields

[louise_atherton]

Hiya

I want to compare values in two different fields using an expression in Qlik:-

1)  [Audits: Vehicle registration]

2) [Risk Assessments: Vehicle registration index]

Both these fields display vehicle registrations and I want to be able to compare  [Audits: Vehicle registration] to [Risk Assessments: Vehicle registration index], to identify which vehicles from the index has not been inspected that day.

Thanks in advance for any suggestions as I'm a bit stumped. 

Louise 

[JordyWegman]

Hi Louise,

I don't have the time to test it. but the way to go is to just add this to the set analysis that you currently have.

=count({$< Date = {"=$(=Today())"}, A =P(B)>*$} A)

 It should be something like this.

Jordy

Climber