topic Re: Unique Flag? in QlikView

Unique Flag?

dmohanty — Mon, 10 Sep 2018 17:46:14 GMT

‌HI all,

This might look simple, but am stuck here. Have a data set like this below -

Name	Country
Chang	Japan
Ashok	USA
Ashok	India
Ashok	Qatar
John	Australia
Mike	UK
Ross	UK
Glen	Germany
Bill	USA
David	UK
Xiomi	China
Ravi	India

Using a load script expression to create an unique flag like this below-

if(match(Country, ‘India’) , ‘Y’ ,

if(match(Country, ‘UK’) , ‘N’

)) as Flag

Need a data set result as below -

Name	Flag
Chang	N
Ashok	Y
Ravi	Y
John	N
Mike	N
Ross	N
Glen	N
Bill	N
David	N
Xiomi	N

IMPORTANT- I don’t need a flag value as N for Ashok and Ravi. My above script is actually generating N value and I don’t need that.

How can I tweak the script?

Re: Unique Flag?

chrismarlow — Mon, 10 Sep 2018 18:36:25 GMT

Not sure I follow. I see the following;

From script;

data:

Load

if(match(Country, 'India') , 'Y' ,

if(match(Country, 'UK') , 'N'

)) as Flag,

;

LOAD * INLINE [

Name, Country

Chang,Japan

Ashok,USA

...

Regards,

Chris.

Re: Unique Flag?

nsetty — Mon, 10 Sep 2018 18:43:43 GMT

Try Mapping....

CountryMap:

Mapping Load * Inline [

CC, Flag

India, Y

];

Data:

LOAD

Name,

Country

, ApplyMap('CountryMap', Country, 'N') AS CFlag

FROM [lib://mypath/country.xlsx]

(ooxml, embedded labels, table is Sheet1);

Re: Unique Flag?

dmohanty — Tue, 11 Sep 2018 05:03:56 GMT

‌Hi ,chrismarlow

Actually I don’t need NULL values in the result table for Ashok.

CAn we a avoid that in any way?

Re: Unique Flag?

chrismarlow — Tue, 11 Sep 2018 12:43:36 GMT

Hello,

Is that because Ashok already scores a Y because of India?

Is the rule here you want distinct names with a Y if they have India at all, N if UK & discard the rest?

Cheers,

Chris.