topic Re: Calculating fields with different tables in QlikView

Calculating fields with different tables

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

Hi Experts,

I Have CASE STATEMENT like below,

CASE WHEN "W_GL_ACCOUNTS_D"."GROUP_ACCOUNT_NUM"='CASH' THEN (CASE WHEN "BICS_GL_LEDGER_D_V"."LEDGER_CURRENCY"='GBP'

THEN "W_GL_BALANCES_F"."BALANCE_LOC_AMOUNT"*1.24

WHEN "BICS_GL_LEDGER_D_V"."LEDGER_CURRENCY"='EUR'

THEN "W_GL_BALANCES_F"."BALANCE_LOC_AMOUNT"*1.07

ELSE "W_GL_BALANCES_F"."BALANCE_LOC_AMOUNT" END ) END CASH

Here, GROUP_ACCOUNT_NUM is from GROUP_ACCOUNT table

LEDGER CURRENCY is from LEDGER Table

BALANCE LOC AMOUNT is from BALANCE Table

can any one help in writing this in a simple way. without if statement.

Is this possible with the Mapping load ?

german24 — Tue, 07 Mar 2017 13:45:46 GMT

Hi,

pelease upload a small sample qvw, without knowing your datamodel and fields it might be difficult to assist.

Regards,

German

adamdavi3s — Tue, 07 Mar 2017 14:14:13 GMT

Why is there a need to simplify this? It looks like good code to me ?