Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Different account names using similar account types

If I have the following accounts:

PREM

WBNR

UBNR

UPR

Where all 4 of them equal Earned Premium, but only PREM and WBNR equal Written Premium, how do I create a mapping table where I can choose Earned and Written Premium as the account summary

Thanks for any help.

1 Reply
bumin
Partner - Creator II
Partner - Creator II

you can create a new field in your script withe the type of account:

if (match(Your-Field,'WBNR','PREM')>0,'Written premum','None') as WrittenIdentification;

If you select WrittenIdentification='Written premum' you wil only have these 2 accounts

regards

Bumin