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.