topic Re: Selecting based on two region fields in QlikView

Selecting based on two region fields

rsdhavle — Wed, 12 Nov 2014 13:08:52 GMT

I have two fields RegionA and RegionB. I want to introduce a new field which will have logic like.

RegionA = 'ASIA' or RegionB ='ASIA' ..I want this logic in new field lets say named RegionC. How can I write it in a generic way?

ashfaq_haseeb — Wed, 12 Nov 2014 13:18:39 GMT

Hi,

May be like this

load *,if(RegionA=RegionA,RegionA) as Region;

LOAD * Inline

[

RegionA,RegionB

Asia,Africa

Africa,Asia

Asia,Asia

];

Regards

ASHFAQ

Gysbert_Wassenaar — Wed, 12 Nov 2014 13:24:37 GMT

rsdhavle — Wed, 12 Nov 2014 13:46:11 GMT

So in my case do I need to compare each and every value From RegionB with Region A like below?

if(FindOneOf('ASIA',RegionB) > 0, RegionA) as RegionC,

rsdhavle — Thu, 13 Nov 2014 12:50:01 GMT

In my case its not working I think. In my case If RegionA is Asia , RegionB can contain different values and vice versa.

And i need to show Combination when RegionA = Asia OR RegionB = Asia