topic Mapping load for fields (not field entries) in QlikView

Mapping load for fields (not field entries)

Anonymous — Wed, 18 Apr 2018 14:06:28 GMT

Hi,

can someone may help me? I want to use a field load when one entry is applicable. I googled alot and tried to find in this forum but I didnt find a solution yet.

Depending on the type different fields should load as "Posting Amount" (But without if-statements)

Is there something like applymap for loading fields as PostingAmount?

I wish to have one field "PostingAmount" which has for Type=Chargeback the Gross Debit (GC) and for Fee the Net Debit (NC) as entries in this field. How can I achieve that? The Info, which Type needs to get which field is already in Excel available. If possible I put a formula in Excel which Qlikview can manage and calculate correct.

Re: Mapping load for fields (not field entries)

bramkn — Wed, 18 Apr 2018 14:22:24 GMT

Dont understand what u want exactly. Have you checked out the crosstable function? Maybe this is something you want to use and probably do something else after doing this first?

Might be helpful if you give a sample of the source data and a sample of what you want to achieve.

Re: Mapping load for fields (not field entries)

el_aprendiz111 — Wed, 18 Apr 2018 21:43:58 GMT

Hi Christian

Would you be able to share a sample with the expected output?

1-option

Mapping TYP:
LOAD * Inline
[
Type,Amount Field
Balancetransfer,Net fields
Chargeback,Gross Debit (GC)
Chargelaacklieversed ,Gross Credit (GC)
Depositcorrection,Net fields
Fee,Net Debit (NC)
Refunded,Gross Debit (GC)
Settled,Gross Credit (GC)
MerchantRayout,Net Debit (NC)
InvoiceDeduction,Net Credit (NC)

];

tbl_Expl:
LOAD *, ApplyMap('TYP',Field,Null()) AS TypField;
LOAD * Inline
[
Field,Value
Balancetransfer,918
Chargeback,646
Chargelaacklieversed ,431
Depositcorrection,1096
Fee,1014
Refunded,447
Settled,662
MerchantRayout,403
InvoiceDeduction,1056
Fee,1102
Settled,593
MerchantRayout,1030
];

Re: Mapping load for fields (not field entries)

Anonymous — Thu, 19 Apr 2018 06:16:24 GMT

Good Morning Jairo,

please find attached the qvw-file.

The output would be that I have a new field, which included regarding to the type the amount column mentioned in the table

My main issue is, that it is always one or value(s) out of four columns.

Re: Mapping load for fields (not field entries)

el_aprendiz111 — Fri, 20 Apr 2018 20:23:53 GMT

Hi Christian