Replace Applymap with IF ELSE or CASE statement

viveksingh — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I have a requirement like I want to convert the Qlik Data model into a query. since Qlik Doesn't gives a query, I manually trying to convert the existing script into a Query.

Now I got a requirement like Applymap needs to be replace with IF else or case statement.

if we have only one argument we in applymap we can simply write it. But i have nested applymap in nested If condition.

below is the code.

if(OPERATING_UNIT_NAME = 'Grafton OU',

ApplyMap('CDBGBusinessUnitMap', Num#(CUSTOMER_TRANSACTION_NUMBER) ,

If(BATCH_SOURCE_NAME = 'PROJECTS INVOICES' AND NOT(IsNull(ACCT_BU)), ApplyMap('TaskOrgBUMap', ACCT_BU, ACCT_BU), ApplyMap('BusinessUnitMapInvoice',BusinessUnitID, 'Other'))),

If(BATCH_SOURCE_NAME = 'PROJECTS INVOICES' AND NOT(IsNull(ACCT_BU)), ApplyMap('TaskOrgBUMap', ACCT_BU, ACCT_BU), ApplyMap('BusinessUnitMapInvoice',BusinessUnitID, 'Other'))

)

Please help me on this.

Re: Replace Applymap with IF ELSE or CASE statement

RonaldDoes — Thu, 01 Feb 2018 12:54:06 GMT

Wouldn't an ApplyMap be best described as an ordinary join in most other languages?

topic Re: Replace Applymap with IF ELSE or CASE statement in QlikView

Replace Applymap with IF ELSE or CASE statement

Re: Replace Applymap with IF ELSE or CASE statement