Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
timsaddler
Creator III
Creator III

Having trouble with WildMatch

Hi all

this may be a brain freeze so apologies in advance...

having some trouble with comparing fields where i need to add up the number of errors

the fields are CPA_ContractNumber and #WAURRF#field (see screenshot)

 i want to report the errors as zero if the fields match

I was hoping wildmatch would do it but it reports 1

thanks

 

screenshotscreenshot

 

 

If(WildMatch(CPA_ContractNumber,#WAURRF#field = 1),0,1)

 

1 Solution

Accepted Solutions
ray_frye
Partner
Partner

So the wildmatch function is used to compare the first parameter to a range of values. If I understand the question correctly, you just want to compare CPA_ContractNumber to the #WAURRF#field on the same record, which you should be able to do with:

If(CPA_ContractNumber = #WAURRF#field, 0, 1)

View solution in original post

2 Replies
ray_frye
Partner
Partner

So the wildmatch function is used to compare the first parameter to a range of values. If I understand the question correctly, you just want to compare CPA_ContractNumber to the #WAURRF#field on the same record, which you should be able to do with:

If(CPA_ContractNumber = #WAURRF#field, 0, 1)

View solution in original post

timsaddler
Creator III
Creator III
Author

thanks @ray_frye 

you will never know how much that simple response has helped in these difficult times