topic Re: Codes are not properly link... in QlikView https://community.qlik.com/t5/QlikView/Codes-are-not-properly-link/m-p/1259520#M856975 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/96544">gwassenaar</A>‌ / All</P><P></P><P>I wanted to do in Qlivkew it self ...</P><P></P><P>Why the Sales and Cogs are not showing product in one line...</P></BODY></HTML> Mon, 13 Feb 2017 06:43:00 GMT Anonymous 2017-02-13T06:43:00Z Codes are not properly link... https://community.qlik.com/t5/QlikView/Codes-are-not-properly-link/m-p/1259517#M856972 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>In application product code are not showing Sales and Cogs in one line.</P><P></P><P>Please check attachment&nbsp; </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Codes-are-not-properly-link/m-p/1259517#M856972 Anonymous 2020-11-25T16:16:04Z Re: Codes are not properly link... https://community.qlik.com/t5/QlikView/Codes-are-not-properly-link/m-p/1259518#M856973 <HTML><HEAD></HEAD><BODY><P>Please drag the line next to Product to increase the space of the cell as you do in excel.</P><P></P><P>Regards</P><P>Pratyush</P></BODY></HTML> Mon, 13 Feb 2017 06:34:55 GMT https://community.qlik.com/t5/QlikView/Codes-are-not-properly-link/m-p/1259518#M856973 prat1507 2017-02-13T06:34:55Z Re: Codes are not properly link... https://community.qlik.com/t5/QlikView/Codes-are-not-properly-link/m-p/1259519#M856974 <HTML><HEAD></HEAD><BODY><P>Ohh, I think I got it wrong, use Sum({1} Sales), Sum({1} COGS).</P><P></P><P>Regards</P><P>Pratyush</P></BODY></HTML> Mon, 13 Feb 2017 06:41:34 GMT https://community.qlik.com/t5/QlikView/Codes-are-not-properly-link/m-p/1259519#M856974 prat1507 2017-02-13T06:41:34Z Re: Codes are not properly link... https://community.qlik.com/t5/QlikView/Codes-are-not-properly-link/m-p/1259520#M856975 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/96544">gwassenaar</A>‌ / All</P><P></P><P>I wanted to do in Qlivkew it self ...</P><P></P><P>Why the Sales and Cogs are not showing product in one line...</P></BODY></HTML> Mon, 13 Feb 2017 06:43:00 GMT https://community.qlik.com/t5/QlikView/Codes-are-not-properly-link/m-p/1259520#M856975 Anonymous 2017-02-13T06:43:00Z Re: Codes are not properly link... https://community.qlik.com/t5/QlikView/Codes-are-not-properly-link/m-p/1259521#M856976 <HTML><HEAD></HEAD><BODY><P>Hi Vijay</P><P><BR />Because they're not properly linked, if you remove the second and third columns (dimensions) in your chart you'll find sales and cogs in the single line.</P><P></P><P>Regards</P><P>Pratyush</P></BODY></HTML> Mon, 13 Feb 2017 06:52:19 GMT https://community.qlik.com/t5/QlikView/Codes-are-not-properly-link/m-p/1259521#M856976 prat1507 2017-02-13T06:52:19Z Re: Codes are not properly link... https://community.qlik.com/t5/QlikView/Codes-are-not-properly-link/m-p/1259522#M856977 <HTML><HEAD></HEAD><BODY><P>Sales have null values for dimension 2 and 3, and COGs have non-null values in these two fields. You need to align the metrics (Sales &amp; COGs) and the dimensions. So either remove dimensions 2 and 3, or modify the load to provide these values to Sales as well as to COGs.</P></BODY></HTML> Mon, 13 Feb 2017 07:05:31 GMT https://community.qlik.com/t5/QlikView/Codes-are-not-properly-link/m-p/1259522#M856977 jonathandienst 2017-02-13T07:05:31Z Re: Codes are not properly link... https://community.qlik.com/t5/QlikView/Codes-are-not-properly-link/m-p/1259523#M856978 <HTML><HEAD></HEAD><BODY><P>Sir,</P><P></P><P>You are right but I bring cogs form different db and sales from db. they don't have any relation between two transaction table expect product code .</P><P></P><P>so how to achieve the same. </P></BODY></HTML> Mon, 13 Feb 2017 07:56:45 GMT https://community.qlik.com/t5/QlikView/Codes-are-not-properly-link/m-p/1259523#M856978 Anonymous 2017-02-13T07:56:45Z