Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
myhammer
Contributor
Contributor

Mapping load for fields (not field entries)

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.

4 Replies
bramkn
Partner
Partner

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.

el_aprendiz111
Specialist
Specialist

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
]
;

myhammer
Contributor
Contributor
Author

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.

BR

el_aprendiz111
Specialist
Specialist

Hi Christian

types.gif