topic Re: How can i map field value to values based on combination in QlikView

How can i map field value to values based on combination

SRT10 — Tue, 25 Jan 2022 06:11:34 GMT

I have a field/column with name as market. It has values like Primary and Secondary

Market

Primary

Secondary

We want a new field with name as UserType and it should be like

If Market is Primary and Secondary then userType shall be Primary

and UserType shall be Secondary when market is Secondary.

can we achieve this. i.e. Primary User shall be mapped with Primary and Secondary Markets and Secondary User shall be mapped with only Secondary market

@JonnyPoole @sunny_talwar @marcus_sommer @rwunderlich

Re: How can i map field value to values based on combination

anat — Tue, 25 Jan 2022 07:24:42 GMT

Market,UserType

Primary,Primary

Secondart,Primary

Seconday,Secondary

Re: How can i map field value to values based on combination

SRT10 — Tue, 25 Jan 2022 09:59:16 GMT

tried this but it is not working. Only Primary is getting exposed and no secondary is available in usertype field

Re: How can i map field value to values based on combination

rwunderlich — Tue, 25 Jan 2022 17:29:04 GMT

When Market is both Primary and Secondary, how does that appear? Is it two rows or both values on the same row? Can you post a screenshot of your data model?

-Rob

Re: How can i map field value to values based on combination

SRT10 — Tue, 25 Jan 2022 17:43:51 GMT

MarketType is field/column name which has values like

1.Primary

2.Secondary

Both are seperate values but under same column name i.e. MarketType

What we want here is we need to generate/derive new field called as UserType which will have values like Primary and Secondary. But here if Primary is selected from UserType then under Market both values shall be allowed to be selected. But if secondary is selected then only Secondary shall be allowed and Primary shall be greyed out.

If(MarketType = 'Primary' and MarketType = 'Secondary' , 'Primary', ) as UserType

If MarketType=Secondary then Secondary as UserType

Script are wrong here...but this is what is expected here.

Away from laptop to share screenshot.

Re: How can i map field value to values based on combination

Qrishna — Wed, 26 Jan 2022 02:34:57 GMT

Hi - If i understood your question correctly, then i believe you gotta group the 'Market Types' and assign a key to that group and call that group id with your 'UserType' Selections. Check below:

Step1: in your script

data:
load * inline [
GroupID, MarketType
1, Primary
1, Secondary
2, Secondary
];

usr_type:
Load * inline [
GroupID, UserType
1, Primary
2, Secondary
];

//no need to join as the table key is same

UI:

With No Selection:

With 'Primary' in UserType Selection:

With 'Secondary' in UserType Selection:

Re: How can i map field value to values based on combination

Sherman99 — Fri, 28 Jan 2022 03:52:34 GMT

@SRT10 wrote:

I have a field/column with name as market. It has values like Primary and Secondary

Market

Primary

Secondary

We want a new field with name as UserType and it should be like

If Market is Primary and Secondary then userType shall be Primary

and UserType shall be Secondary when market is Secondary.

can we achieve this. i.e. Primary User shall be mapped with Primary and Secondary Markets and Secondary User shall be mapped with only Secondary market

@JonnyPoole @sunny_talwar @marcus_sommer @rwunderlich official Tellthebell Survey

Is it two rows or both values on the same row? Can you post a screenshot of your data model?