Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rams_school
New Contributor III

How to Map ProductGroupCode to a String in Qlik Sense?

I am working on a material list. We have a field called MetalCode

Something similar to below

MetalCode

1001

1002

1003

1004

1005

Unfortunately this code everyone memorise and familiar. I want to replace this code to a String in report so that anyone can understand easily

.

i.e when User select 1001, the report should display MetalName  instead of code. Like

Report for 1001 - Aluminium

The Matching Metal name as follows

1001  -  Aluminium

1002 - Copper

1003 - Silver

1004 - Gold

1005 - Steel

Any suggestion ? Inputs please..

Thanks

1 Reply
galax_allu
Valued Contributor

Re: How to Map ProductGroupCode to a String in Qlik Sense?

Hi

Are you asking form mapping code ?

TABLE1:

MAPPING

LOAD * INLINE

[

MetalCode, Name

1001, Aluminium

1002, Copper

1003, Silver

1004, Gold

1005, Steel

];

TABLE2:

Load Price,

ApplyMap('TABLE1', MetalCode, 'Metalcodenotexists') as Newmetalname

inline

[

MetalCode, Price

1001, 1000

1002, 2550

1003, 45500

1006, 4778

]

;