This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
hi every one
i have filed which contains of many codes and codes are stating with an alphabet
and each alphabet represents category
for example if my code is : A1234 it means it bongs to "APPLE" category
so now as bellow i want to rename all of the cods as bellow:
can some one please help me to reach to the "NEW_CODE" ?:
May be like:
Pick(Match( Left(OLD_CODE, 1), 'A', 'B', 'C', 'D', 'E'), 'Apple', 'Big', 'Cat', 'Dog', 'Egg') as NEW_CODE
And if you have many such codes, you may try with Applymap() / MapSubString()
View solution in original post
Thanks it works