topic Matrix rule lookup in QlikView https://community.qlik.com/t5/QlikView/Matrix-rule-lookup/m-p/1027606#M936146 <HTML><HEAD></HEAD><BODY><P>Hi all, need some advice please on best possible approach to my problem. </P><P></P><P>I have created a simplified version of my requirement, essentially I have data loaded ina Fact table and need to adjust the values in some fields depending on a rule matrix.</P><P></P><P>E.g. if Company is classed as Domestic then I need to add or subtract the value of its sales in the current field to a different field, if a company is classed as both Domestic and Foreign then the values remain as they are. </P><P></P><P>In the screen shot Company A values in Header 1 should be move to Header 2, Company B values for Header 2&nbsp; stay in Header 2.</P><P><IMG alt="Supplier_Example.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/114563_Supplier_Example.PNG" style="height: 145px; width: 620px;" /></P><P>I have provided a sample of the Matrix rule spreadsheet as it is but this can be amended to fit the solution if required.</P><P></P><P>Many thanks in advance!!!</P></BODY></HTML> Sat, 13 Feb 2016 13:54:45 GMT 2016-02-13T13:54:45Z Matrix rule lookup https://community.qlik.com/t5/QlikView/Matrix-rule-lookup/m-p/1027606#M936146 <HTML><HEAD></HEAD><BODY><P>Hi all, need some advice please on best possible approach to my problem. </P><P></P><P>I have created a simplified version of my requirement, essentially I have data loaded ina Fact table and need to adjust the values in some fields depending on a rule matrix.</P><P></P><P>E.g. if Company is classed as Domestic then I need to add or subtract the value of its sales in the current field to a different field, if a company is classed as both Domestic and Foreign then the values remain as they are. </P><P></P><P>In the screen shot Company A values in Header 1 should be move to Header 2, Company B values for Header 2&nbsp; stay in Header 2.</P><P><IMG alt="Supplier_Example.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/114563_Supplier_Example.PNG" style="height: 145px; width: 620px;" /></P><P>I have provided a sample of the Matrix rule spreadsheet as it is but this can be amended to fit the solution if required.</P><P></P><P>Many thanks in advance!!!</P></BODY></HTML> Sat, 13 Feb 2016 13:54:45 GMT https://community.qlik.com/t5/QlikView/Matrix-rule-lookup/m-p/1027606#M936146 2016-02-13T13:54:45Z