Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
anwarbham
Contributor III
Contributor III

pick Match Formula Simplify

Hi 

Im trying to group a set of accounts and with the resulting group assign a new account number.

im using pick match it seem to do the job, but . for every Match i have to add the same new account number 

is there anyway of just setting the new account number once instead of repeating the new account number 20 times 

example is the formula below. if  teh accounts are found in [pnl_code] then assign it  9030000000 

 

thanks

 

pick(Match([pnl_code],

 '3010111100',

 '3010111200',

 '3010112100',

 '3010112300',

 '3010113100',

 '3010113200',

 '3010210000',

 '3010220000',

 '3010620000',

 '3010621000',

 '3010631001',

 '3010631002',

 '3010632001',

 '3010641000',

 '3010642000',

 '3010800000',

 '3010910000',

 '3010930000',

 '3010943000',

 '3010944000',

 '3010945000',

 '3012000000',

 '3010115001',

 '3010115002')

 ,'9030000000'

 ,'9030000000'

 ,'9030000000'

 ,'9030000000'

 ,'9030000000'

 ,'9030000000'

 ,'9030000000'

 ,'9030000000'

,'9030000000'

,'9030000000'

,'9030000000'

,'9030000000'

,'9030000000'

,'9030000000'

,'9030000000'

,'9030000000'

,'9030000000'

,'9030000000'

,'9030000000'

,'9030000000'

,'9030000000'

,'9030000000'

,'9030000000'

,'9030000000')

Labels (3)
1 Solution

Accepted Solutions
DavidM
Partner - Creator II
Partner - Creator II

you can simplify it with:

 

if(match(your list), '9030000000',original value)

 

However how about making a table (either xls or inline) and the using applymap?

View solution in original post

2 Replies
DavidM
Partner - Creator II
Partner - Creator II

you can simplify it with:

 

if(match(your list), '9030000000',original value)

 

However how about making a table (either xls or inline) and the using applymap?

anwarbham
Contributor III
Contributor III
Author

i was thinking about using applymap might give it a try