topic Re: Excel file carry two types under two rows in QlikView https://community.qlik.com/t5/QlikView/Excel-file-carry-two-types-under-two-rows/m-p/51134#M776335 <HTML><HEAD></HEAD><BODY><P>Like Attached?</P><P>change the expression RECOVERY_BF</P><P>to IF(Aggr(Count(RECOVERY_TYP),CLAIM_NO)&gt;1,Sum (RECOVERY_BF))</P></BODY></HTML> Wed, 18 Apr 2018 18:57:01 GMT sasiparupudi1 2018-04-18T18:57:01Z Excel file carry two types under two rows https://community.qlik.com/t5/QlikView/Excel-file-carry-two-types-under-two-rows/m-p/51133#M776334 <HTML><HEAD></HEAD><BODY><P>Dear Experts!</P><P></P><P>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 &amp; 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)</P><P>Claim_no&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Recovery_type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Recovery_BF&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CLRECBL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RFCBL</P><P>CLAS00TC17000001&nbsp;&nbsp;&nbsp;&nbsp; Foreign_recovery&nbsp;&nbsp;&nbsp;&nbsp; 100500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -</P><P>CLAS00TC17000001&nbsp;&nbsp;&nbsp;&nbsp; Reinsurance Fund&nbsp;&nbsp;&nbsp;&nbsp; 6000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6000</P><P></P><P>If I am to show as above all cases where balances are appeared under both recovery types, what adjustment to be made!</P><P></P><P>Many Thanks</P><P></P><P>Neville</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Excel-file-carry-two-types-under-two-rows/m-p/51133#M776334 nevilledhamsiri 2020-11-25T16:16:04Z Re: Excel file carry two types under two rows https://community.qlik.com/t5/QlikView/Excel-file-carry-two-types-under-two-rows/m-p/51134#M776335 <HTML><HEAD></HEAD><BODY><P>Like Attached?</P><P>change the expression RECOVERY_BF</P><P>to IF(Aggr(Count(RECOVERY_TYP),CLAIM_NO)&gt;1,Sum (RECOVERY_BF))</P></BODY></HTML> Wed, 18 Apr 2018 18:57:01 GMT https://community.qlik.com/t5/QlikView/Excel-file-carry-two-types-under-two-rows/m-p/51134#M776335 sasiparupudi1 2018-04-18T18:57:01Z Re: Excel file carry two types under two rows https://community.qlik.com/t5/QlikView/Excel-file-carry-two-types-under-two-rows/m-p/51135#M776336 <HTML><HEAD></HEAD><BODY><P>Thank a lot Sasidhar</P><P></P><P>Neville</P></BODY></HTML> Thu, 19 Apr 2018 01:50:21 GMT https://community.qlik.com/t5/QlikView/Excel-file-carry-two-types-under-two-rows/m-p/51135#M776336 nevilledhamsiri 2018-04-19T01:50:21Z