Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

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
Highlighted
Master III
Master 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))

View solution in original post

2 Replies
Highlighted
Master III
Master 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))

View solution in original post

Highlighted
Specialist
Specialist

Re: Excel file carry two types under two rows

Thank a lot Sasidhar

Neville