topic Re: Count if match 2 fields in any order in QlikView

Count if match 2 fields in any order

cbaqir — Tue, 23 Oct 2018 15:20:34 GMT

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?

Re: Count if match 2 fields in any order

sunny_talwar — Tue, 23 Oct 2018 15:25:06 GMT

How do you combine them? May be combine them like this

RangeMaxString(FIELDA, FIELDB) & '_' & RangeMinString(FIELDA, FIELDB) as COMBINED_FIELD

Re: Count if match 2 fields in any order

cbaqir — Tue, 23 Oct 2018 17:36:59 GMT

I was using FIELDA & '-' & FIELDB as FIELDA_FIELDB

Re: Count if match 2 fields in any order

cbaqir — Tue, 23 Oct 2018 21:12:20 GMT

Sunny,

When I add the combined field as a dimension, I am still seeing one option for A_B and one for B_A.

What I am after is a way to combine them here. Any ideas?

Re: Count if match 2 fields in any order

swuehl — Tue, 23 Oct 2018 21:26:47 GMT

Are you really sure you are using Sunny's suggested calculated field and not yours?