topic Re: Filling missing row with Scripting in QlikView https://community.qlik.com/t5/QlikView/Filling-missing-row-with-Scripting/m-p/632639#M232127 <HTML><HEAD></HEAD><BODY><P>Ok, hehe.</P><P></P><P>Now imagine another table with more than 300 countries and scores by month. </P><P></P><P>I can not do this by hand.</P><P></P><P>I need a way I can generate hundreds of these missing countries.</P></BODY></HTML> Thu, 29 May 2014 13:40:35 GMT 2014-05-29T13:40:35Z Filling missing row with Scripting https://community.qlik.com/t5/QlikView/Filling-missing-row-with-Scripting/m-p/632637#M232125 <HTML><HEAD></HEAD><BODY><P>Hi, all,</P><P>I'm stuck with this. We take these two tabs:</P><P></P><P>TAB1:</P><P>load * inline [</P><P>country, points</P><P>Brazil, 234</P><P>US, 432</P><P>Germany, 121</P><P>India, 444];</P><P></P><P>TAB2:</P><P>load * inline [</P><P>country, points</P><P>US, 412</P><P>Germany, 488</P><P>India, 224];</P><P></P><P>Note that Brazil will not appear into TAB2 because it didn't score points. But I need to see it there showing 0 point.</P><P></P><P>So, how I do create&nbsp; a row into TAB2 with: <SPAN style="font-size: 10pt; line-height: 1.5em;">'Brazil, 0' </SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">???</SPAN></P></BODY></HTML> Thu, 29 May 2014 13:34:43 GMT https://community.qlik.com/t5/QlikView/Filling-missing-row-with-Scripting/m-p/632637#M232125 2014-05-29T13:34:43Z Re: Filling missing row with Scripting https://community.qlik.com/t5/QlikView/Filling-missing-row-with-Scripting/m-p/632638#M232126 <HTML><HEAD></HEAD><BODY><P>TAB1:</P><P>load * inline [</P><P>country, points</P><P>Brazil, 234</P><P>US, 432</P><P>Germany, 121</P><P>India, 444];</P><P></P><P>TAB2:</P><P>load * inline [</P><P>country, points</P><P>Brazil, 0</P><P>US, 412</P><P>Germany, 488</P><P>India, 224];</P></BODY></HTML> Thu, 29 May 2014 13:37:09 GMT https://community.qlik.com/t5/QlikView/Filling-missing-row-with-Scripting/m-p/632638#M232126 2014-05-29T13:37:09Z Re: Filling missing row with Scripting https://community.qlik.com/t5/QlikView/Filling-missing-row-with-Scripting/m-p/632639#M232127 <HTML><HEAD></HEAD><BODY><P>Ok, hehe.</P><P></P><P>Now imagine another table with more than 300 countries and scores by month. </P><P></P><P>I can not do this by hand.</P><P></P><P>I need a way I can generate hundreds of these missing countries.</P></BODY></HTML> Thu, 29 May 2014 13:40:35 GMT https://community.qlik.com/t5/QlikView/Filling-missing-row-with-Scripting/m-p/632639#M232127 2014-05-29T13:40:35Z Re: Filling missing row with Scripting https://community.qlik.com/t5/QlikView/Filling-missing-row-with-Scripting/m-p/632640#M232128 <HTML><HEAD></HEAD><BODY><P>Hmmmm well in that case I'm trying to think of a way you could choose a way to join those inline tables to a table with scores of all zeros so that you only add the zero entry if there is no other entry</P></BODY></HTML> Thu, 29 May 2014 13:49:11 GMT https://community.qlik.com/t5/QlikView/Filling-missing-row-with-Scripting/m-p/632640#M232128 2014-05-29T13:49:11Z Re: Filling missing row with Scripting https://community.qlik.com/t5/QlikView/Filling-missing-row-with-Scripting/m-p/632641#M232129 <HTML><HEAD></HEAD><BODY><P>Hi, Bernardo.</P><P></P><P>You can do something&nbsp; like this:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_1401371295245758" jivemacro_uid="_1401371295245758" modifiedtitle="true"> <P>TAB1:</P> <P>load * inline [</P> <P>country, points</P> <P>Brazil, 234</P> <P>US, 432</P> <P>Germany, 121</P> <P>India, 444];</P> <P></P> <P>TAB2:</P> <P>NoConcatenate load * inline [</P> <P>country, points</P> <P>US, 412</P> <P>Germany, 488</P> <P>India, 224];</P> <P></P> <P>Outer Join (TAB2) Load</P> <P>&nbsp; country</P> <P>Resident TAB1;</P> <P></P> <P>TAB2_Definitive:</P> <P>NoConcatenate Load</P> <P>&nbsp; country,</P> <P>&nbsp; if(IsNull(points), 0, points) as points</P> <P>Resident TAB2;</P> <P><SPAN style="font-size: 9pt; line-height: 12pt;"><BR /></SPAN></P> <P><SPAN style="font-size: 9pt; line-height: 12pt;">Drop Table TAB2;</SPAN></P> </PRE><P></P><P>That is just a guide. Attached is a sample app. Notice the synthetic you should avoid.</P><P></P><P>Cheers. </P></BODY></HTML> Thu, 29 May 2014 13:51:16 GMT https://community.qlik.com/t5/QlikView/Filling-missing-row-with-Scripting/m-p/632641#M232129 Anonymous 2014-05-29T13:51:16Z Re: Filling missing row with Scripting https://community.qlik.com/t5/QlikView/Filling-missing-row-with-Scripting/m-p/632642#M232130 <HTML><HEAD></HEAD><BODY><P>TAB1:</P><P>load * inline [</P><P>country, points</P><P>Brazil, 234</P><P>US, 432</P><P>Germany, 121</P><P>India, 444];</P><P></P><P></P><P>TAB2:</P><P>load country1, points1 inline [</P><P>country1, points1</P><P>US, 412</P><P>Germany, 488</P><P>India, 224];</P><P>Concatenate</P><P>Load country as country1, 0 as points1 Resident TAB1 Where Not Exists(country1,country);</P></BODY></HTML> Thu, 29 May 2014 14:03:04 GMT https://community.qlik.com/t5/QlikView/Filling-missing-row-with-Scripting/m-p/632642#M232130 anbu1984 2014-05-29T14:03:04Z Re: Filling missing row with Scripting https://community.qlik.com/t5/QlikView/Filling-missing-row-with-Scripting/m-p/632643#M232131 <HTML><HEAD></HEAD><BODY><P>Thanks you, guys. Well done.</P><P></P><P>The last answers were helpful for my project.</P></BODY></HTML> Thu, 29 May 2014 19:56:59 GMT https://community.qlik.com/t5/QlikView/Filling-missing-row-with-Scripting/m-p/632643#M232131 2014-05-29T19:56:59Z Re: Filling missing row with Scripting https://community.qlik.com/t5/QlikView/Filling-missing-row-with-Scripting/m-p/632644#M232132 <HTML><HEAD></HEAD><BODY><P>You're welcome.</P><P></P><P>Glad I could be of hep.</P><P></P><P>Regards.</P></BODY></HTML> Thu, 29 May 2014 20:00:55 GMT https://community.qlik.com/t5/QlikView/Filling-missing-row-with-Scripting/m-p/632644#M232132 Anonymous 2014-05-29T20:00:55Z