topic Count if match 2 fields in any order in QlikView https://community.qlik.com/t5/QlikView/Count-if-match-2-fields-in-any-order/m-p/129756#M509714 <HTML><HEAD></HEAD><BODY><P>I have FIELDA and FIELDB and I concatenate them in the script to be FIELDA_FIELDB. I then do a count to see how many occurrences we have of the matching pair of fields count(FIELDA_FIELDB). However, sometimes the same values could be listed as FIELDB_FIELDA. I want to group them together when the 2 fields are the same, regardless of which order they are in. Is there a way to do that?</P></BODY></HTML> Tue, 23 Oct 2018 15:07:57 GMT cbaqir 2018-10-23T15:07:57Z Count if match 2 fields in any order https://community.qlik.com/t5/QlikView/Count-if-match-2-fields-in-any-order/m-p/129756#M509714 <HTML><HEAD></HEAD><BODY><P>I have FIELDA and FIELDB and I concatenate them in the script to be FIELDA_FIELDB. I then do a count to see how many occurrences we have of the matching pair of fields count(FIELDA_FIELDB). However, sometimes the same values could be listed as FIELDB_FIELDA. I want to group them together when the 2 fields are the same, regardless of which order they are in. Is there a way to do that?</P></BODY></HTML> Tue, 23 Oct 2018 15:07:57 GMT https://community.qlik.com/t5/QlikView/Count-if-match-2-fields-in-any-order/m-p/129756#M509714 cbaqir 2018-10-23T15:07:57Z Re: Count if match 2 fields in any order https://community.qlik.com/t5/QlikView/Count-if-match-2-fields-in-any-order/m-p/129757#M509715 <HTML><HEAD></HEAD><BODY><P>explain the issue with an example</P></BODY></HTML> Tue, 23 Oct 2018 15:14:36 GMT https://community.qlik.com/t5/QlikView/Count-if-match-2-fields-in-any-order/m-p/129757#M509715 YoussefBelloum 2018-10-23T15:14:36Z Re: Count if match 2 fields in any order https://community.qlik.com/t5/QlikView/Count-if-match-2-fields-in-any-order/m-p/129758#M509716 <HTML><HEAD></HEAD><BODY><P>Check here</P><P><A href="https://community.qlik.com/thread/317702">Count if match 2 fields in any order</A></P></BODY></HTML> Tue, 23 Oct 2018 15:25:40 GMT https://community.qlik.com/t5/QlikView/Count-if-match-2-fields-in-any-order/m-p/129758#M509716 sunny_talwar 2018-10-23T15:25:40Z