topic HELP in App Development https://community.qlik.com/t5/App-Development/HELP/m-p/1537393#M40395 <P>Dear Team,</P><P>i Stuck a requirement. Please help me for sort out this problem.</P><P>Requirement is</P><P>Suppose in my fact table</P><P>code&nbsp; &nbsp; &nbsp; Sale</P><P>Z121&nbsp; &nbsp; &nbsp; &nbsp;100</P><P>Z222&nbsp; &nbsp; &nbsp; &nbsp;200</P><P>AND a code master contain a hierachy.like deatils</P><P>means code wise mapping details</P><P>z121&nbsp; &nbsp; &nbsp;A</P><P>Z121&nbsp; &nbsp; &nbsp;B</P><P>Z121&nbsp; &nbsp; &nbsp; C</P><P>Z222&nbsp; &nbsp; &nbsp; &nbsp;D</P><P>Z222&nbsp; &nbsp; &nbsp; &nbsp;E</P><P>&nbsp;</P><P>When i left join Code master to fact.THEN RESULT BELOW</P><P>&nbsp;</P><P>CODE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DEATILS&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Sale</P><P>Z121&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100</P><P>Z121&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100</P><P>Z121&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100</P><P>Z222&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200</P><P>Z222&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; E&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;200</P><P>&nbsp;</P><P>Requirement is when i left join code master to fact then deatils wise sale which is showing above it should be zero(0)</P><P>and z121 wise sale showing 100</P><P>z222 wise 200</P><P>output format i show you</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>CODE</TD><TD>DETAILS</TD><TD>Sale</TD></TR><TR><TD>&nbsp;</TD><TD>Z121</TD><TD>100</TD></TR><TR><TD>Z121</TD><TD>A</TD><TD>0</TD></TR><TR><TD>B</TD><TD>0</TD></TR><TR><TD>C</TD><TD>0</TD></TR><TR><TD>&nbsp;</TD><TD>Z222</TD><TD>200</TD></TR><TR><TD>Z222</TD><TD>D</TD><TD>0</TD></TR><TR><TD>E</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;KINDLY HELP ME FOR SOLVING THIS ISSUE.</P> Sat, 16 Nov 2024 06:43:03 GMT GauravKumar1 2024-11-16T06:43:03Z HELP https://community.qlik.com/t5/App-Development/HELP/m-p/1537393#M40395 <P>Dear Team,</P><P>i Stuck a requirement. Please help me for sort out this problem.</P><P>Requirement is</P><P>Suppose in my fact table</P><P>code&nbsp; &nbsp; &nbsp; Sale</P><P>Z121&nbsp; &nbsp; &nbsp; &nbsp;100</P><P>Z222&nbsp; &nbsp; &nbsp; &nbsp;200</P><P>AND a code master contain a hierachy.like deatils</P><P>means code wise mapping details</P><P>z121&nbsp; &nbsp; &nbsp;A</P><P>Z121&nbsp; &nbsp; &nbsp;B</P><P>Z121&nbsp; &nbsp; &nbsp; C</P><P>Z222&nbsp; &nbsp; &nbsp; &nbsp;D</P><P>Z222&nbsp; &nbsp; &nbsp; &nbsp;E</P><P>&nbsp;</P><P>When i left join Code master to fact.THEN RESULT BELOW</P><P>&nbsp;</P><P>CODE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DEATILS&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Sale</P><P>Z121&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100</P><P>Z121&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100</P><P>Z121&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100</P><P>Z222&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200</P><P>Z222&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; E&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;200</P><P>&nbsp;</P><P>Requirement is when i left join code master to fact then deatils wise sale which is showing above it should be zero(0)</P><P>and z121 wise sale showing 100</P><P>z222 wise 200</P><P>output format i show you</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>CODE</TD><TD>DETAILS</TD><TD>Sale</TD></TR><TR><TD>&nbsp;</TD><TD>Z121</TD><TD>100</TD></TR><TR><TD>Z121</TD><TD>A</TD><TD>0</TD></TR><TR><TD>B</TD><TD>0</TD></TR><TR><TD>C</TD><TD>0</TD></TR><TR><TD>&nbsp;</TD><TD>Z222</TD><TD>200</TD></TR><TR><TD>Z222</TD><TD>D</TD><TD>0</TD></TR><TR><TD>E</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;KINDLY HELP ME FOR SOLVING THIS ISSUE.</P> Sat, 16 Nov 2024 06:43:03 GMT https://community.qlik.com/t5/App-Development/HELP/m-p/1537393#M40395 GauravKumar1 2024-11-16T06:43:03Z Re: HELP https://community.qlik.com/t5/App-Development/HELP/m-p/1537399#M40396 CODE DETAILS Sale<BR />Z121 100<BR />Z121 A 0<BR />B 0<BR />C 0<BR />Z222 200<BR />Z222 D 0<BR />E 0<BR />CODE WISE GROUP DEATILS Wed, 30 Jan 2019 17:41:18 GMT https://community.qlik.com/t5/App-Development/HELP/m-p/1537399#M40396 GauravKumar1 2019-01-30T17:41:18Z Re: HELP https://community.qlik.com/t5/App-Development/HELP/m-p/1537402#M40397 <P>OUTPUT IS SCREEN SHOT IS ATTACHED.KINDLY SEE</P> Wed, 30 Jan 2019 17:47:14 GMT https://community.qlik.com/t5/App-Development/HELP/m-p/1537402#M40397 GauravKumar1 2019-01-30T17:47:14Z Re: HELP https://community.qlik.com/t5/App-Development/HELP/m-p/1537403#M40398 <P>OUTPUT IS SCREEN SHOT IS ATTACHED.KINDLY SEE</P> Wed, 30 Jan 2019 17:47:32 GMT https://community.qlik.com/t5/App-Development/HELP/m-p/1537403#M40398 GauravKumar1 2019-01-30T17:47:32Z Re: HELP https://community.qlik.com/t5/App-Development/HELP/m-p/1537404#M40399 <P>OUTPUT IS SCREEN SHOT IS ATTACHED.KINDLY SEE</P> Wed, 30 Jan 2019 17:47:35 GMT https://community.qlik.com/t5/App-Development/HELP/m-p/1537404#M40399 GauravKumar1 2019-01-30T17:47:35Z