Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

nevilledhamsiri
Valued Contributor

Excel file carry two types under two rows

Dear Experts!

As per the two tables where one table carries recovery types under two rows(RECOVERY_BF) but the other file it is shown under two dimensions (CLRECBL & RFCBAL). When both files are loaded, when balances under both types appear, it is appeared twice. Can you please suggest as to how it could be made appear something like below! (Sample case)

Claim_no                    Recovery_type          Recovery_BF               CLRECBL               RFCBL

CLAS00TC17000001     Foreign_recovery     100500                         100500                    -

CLAS00TC17000001     Reinsurance Fund     6000                              -                         6000

If I am to show as above all cases where balances are appeared under both recovery types, what adjustment to be made!

Many Thanks

Neville

1 Solution

Accepted Solutions
sasiparupudi1
Honored Contributor III

Re: Excel file carry two types under two rows

Like Attached?

change the expression RECOVERY_BF

to IF(Aggr(Count(RECOVERY_TYP),CLAIM_NO)>1,Sum (RECOVERY_BF))

2 Replies
sasiparupudi1
Honored Contributor III

Re: Excel file carry two types under two rows

Like Attached?

change the expression RECOVERY_BF

to IF(Aggr(Count(RECOVERY_TYP),CLAIM_NO)>1,Sum (RECOVERY_BF))

nevilledhamsiri
Valued Contributor

Re: Excel file carry two types under two rows

Thank a lot Sasidhar

Neville

Community Browser