topic Re: Straight table comparison in QlikView https://community.qlik.com/t5/QlikView/Straight-table-comparison/m-p/1241674#M394267 <HTML><HEAD></HEAD><BODY><P>It depends on the underlying data structure. I suspect you may need a load modification to create the field PRODUCT CODE derived from FERMAT_PRODUCT_CODE and MIS_PRODUCT_CODE and then you can simply use this for the table dimension -- It is pretty complicated to combine two fields into a single dimension in the front end.</P><P></P><P>Exactly how you do that depends on your data sources. Are you loading both product codes and values from the same source tables/files?</P></BODY></HTML> Thu, 09 Feb 2017 08:51:12 GMT jonathandienst 2017-02-09T08:51:12Z Straight table comparison https://community.qlik.com/t5/QlikView/Straight-table-comparison/m-p/1241673#M394266 <HTML><HEAD></HEAD><BODY><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/152547_pastedImage_2.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>I have this straight table. If FERMAT_PRODUCT_CODE and MIS_PRODUCT_CODE matches, I want to display it in a way that is like something below. If it does not match, then just display the amount of its respective field like below.</P><P></P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/152548_pastedImage_3.png" style="max-height: 900px; max-width: 1200px;" /></P><P>So for the above excel sheet, it shows fermat amount and mis amount because in the data, the fermat_product_code and mis_product_code matches. There is a product of 125 for both of them. but for product code 124, only fermat_product_code has the value 124 while mis_product_code does not. therefore it only displays the fermat amount for fermat_product_code and not mis_product_code. Likewise for 145.</P><P></P><P>How do I get qlikview to display it this way so I can export to excel? </P></BODY></HTML> Thu, 09 Feb 2017 08:23:18 GMT https://community.qlik.com/t5/QlikView/Straight-table-comparison/m-p/1241673#M394266 2017-02-09T08:23:18Z Re: Straight table comparison https://community.qlik.com/t5/QlikView/Straight-table-comparison/m-p/1241674#M394267 <HTML><HEAD></HEAD><BODY><P>It depends on the underlying data structure. I suspect you may need a load modification to create the field PRODUCT CODE derived from FERMAT_PRODUCT_CODE and MIS_PRODUCT_CODE and then you can simply use this for the table dimension -- It is pretty complicated to combine two fields into a single dimension in the front end.</P><P></P><P>Exactly how you do that depends on your data sources. Are you loading both product codes and values from the same source tables/files?</P></BODY></HTML> Thu, 09 Feb 2017 08:51:12 GMT https://community.qlik.com/t5/QlikView/Straight-table-comparison/m-p/1241674#M394267 jonathandienst 2017-02-09T08:51:12Z