Discussion Board for collaboration on QlikView Scripting.
i have the following type of data
with the acctcode and acctname, i have to extract the name(respective acctname) for Level 1 field, and other 4 levels fields
please help me to get the desired result.
it is do in the script and get names for all level fields.
Thanks in advance,
Go to Solution.
everybody who refer this discussion....
i have solved it by myself using applymap...
Mapping Load Acctcode,
ApplyMap('SegMap',[Level 1],'N/A') as L1Name,
ApplyMap('SegMap',[Level 2],'N/A') as L2Name,
ApplyMap('SegMap',[Level 3],'N/A') as L3Name,
ApplyMap('SegMap',[Level 4],'N/A') as L4Name,
ApplyMap('SegMap',[Level 5],'N/A') as L5Name
I have extracted names from the AcctName to the respective Levels successfully..
It's not clear from the picture above if the acctcode and acctname are join together.
However, best bet will be to use Subfield()
subfield(S, ';' ,2)
returns 'cde' if S is 'abc;cde;efg'
subfield(S, ';' ,1)
returns NULL if S is an empty string
Try Subfield and let us know if it workd.
acctcode is seperate...numbers(integer)
acctname is character...
are you able to see the levels(1-5)?
level1 is integer...
but i need level1name by using the acctname...
AcctName as L1Name
where Level 1 = AcctCode;
whehther this script will be correct or not?
but i cant get exact names by using this scripting