I did not understand what you mean by this:
What happens is that qlik sense gets confuse and, for example, if AllocTransfOrigMarketCd= 10, it should be placed in the group of a single value called AllocTransfOrigMktDescrip=PORTUGAL but, instead, currently this group may aggregate much more AllocTransfOrigMarketCd values...
what is the expected values when the source field =10, it should be Portugal because you didn't mention the value 10 on your if(match())....
can you elaborate more please ?
Thank you youssef.
Let's say this dimension is called Office. If AllocTransfOrigMarketCd is not mentioned on any match function of Office definition, the name of the group of that field in the dimension Office should be correspondent AllocTransfOrigMktDescrip.
For example, as AllocTransfOrigMarketCd= 10 is not mentioned, it should be include in a group called PORTUGAL