topic Help with mapping data in QlikView

Help with mapping data

Thu, 08 Oct 2015 11:18:40 GMT

Hey guys

I have two fields in a table that i would like to map but dont have a clue how.

There is numbers like this FPWO0006-15+0001 which i would like to map to FPWO so that when i select FPWO then all of them will show and also in the same table numbers like this PCWO0006-15+0001 which i would like to map aswell to PCWO.

Is there a way i can do this in the load script ?

Your help will be greatly appreciated.

Re: Help with mapping data

maxgro — Thu, 08 Oct 2015 11:22:40 GMT

if your map is always the first 4 chars

you can add a field in the script

left(yourfield, 4) as newfield

and then add a listbox for newfield

Re: Help with mapping data

malini_qlikview — Thu, 08 Oct 2015 11:27:20 GMT

Hi,

if you are looking to remove the numbers and operators in the field and retain only text then you can try the below

Purgechar('Fieldname','0123456789+-*/')

Re: Help with mapping data

avinashelite — Thu, 08 Oct 2015 11:27:34 GMT

please share the sample set of data

Re: Help with mapping data

Thu, 08 Oct 2015 13:03:02 GMT

you can use Purgechar or Left funtions to extract the piece from field value & then use ApplyMap like below:

ApplyMap('Map_table', Left(FieldName,4) , Null() ) AS NewField

ApplyMap('Map_table', Purgechar(FieldName,'0123456789+-/') , Null() ) AS NewField

If you always have first 4 char is your required value then go with Left function.