topic Re: For Loop in QlikView https://community.qlik.com/t5/QlikView/For-Loop/m-p/309933#M1191357 <HTML><HEAD></HEAD><BODY><P>Here's one way to do it:</P><P> </P><P>data:</P><P></P><P>load *</P><P></P><P>inline [serialNo</P><P></P><P>;</P><P></P><P>extras:</P><P></P><P>load *</P><P></P><P>inline [extra</P><P></P><P>;</P><P></P><P>crossjoin:</P><P></P><P>load serialNo as ser</P><P></P><P>Resident data;</P><P></P><P>outer join</P><P></P><P>load extra as X</P><P></P><P>Resident extras;</P><P></P><P>extendedlist:</P><P></P><P>load ser+X as series</P><P></P><P>resident crossjoin;</P><P></P><P>drop Tables crossjoin, extras;</P></BODY></HTML> Wed, 27 Jul 2011 07:29:39 GMT gussfish 2011-07-27T07:29:39Z For Loop https://community.qlik.com/t5/QlikView/For-Loop/m-p/309932#M1191355 <HTML><HEAD></HEAD><BODY><P>Hi All !</P><P>I need some help...</P><P>I have a table ...</P><P>in this table i have a field as 'serialNo.'&nbsp; whose values are as&nbsp; 101,201,301,401...nd so on...</P><P></P><P>Nw i want to generate a series for each of the above value.</P><P></P><P>Like:</P><P></P><P>For Value : 101</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 102</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 103</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 104</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 105</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 106</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 107</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 110</P><P></P><P>Similarly for Value 201...</P></BODY></HTML> Wed, 27 Jul 2011 06:13:27 GMT https://community.qlik.com/t5/QlikView/For-Loop/m-p/309932#M1191355 2011-07-27T06:13:27Z Re: For Loop https://community.qlik.com/t5/QlikView/For-Loop/m-p/309933#M1191357 <HTML><HEAD></HEAD><BODY><P>Here's one way to do it:</P><P> </P><P>data:</P><P></P><P>load *</P><P></P><P>inline [serialNo</P><P></P><P>;</P><P></P><P>extras:</P><P></P><P>load *</P><P></P><P>inline [extra</P><P></P><P>;</P><P></P><P>crossjoin:</P><P></P><P>load serialNo as ser</P><P></P><P>Resident data;</P><P></P><P>outer join</P><P></P><P>load extra as X</P><P></P><P>Resident extras;</P><P></P><P>extendedlist:</P><P></P><P>load ser+X as series</P><P></P><P>resident crossjoin;</P><P></P><P>drop Tables crossjoin, extras;</P></BODY></HTML> Wed, 27 Jul 2011 07:29:39 GMT https://community.qlik.com/t5/QlikView/For-Loop/m-p/309933#M1191357 gussfish 2011-07-27T07:29:39Z For Loop https://community.qlik.com/t5/QlikView/For-Loop/m-p/309934#M1191359 <HTML><HEAD></HEAD><BODY><P>Thnx For the Reply...but I didn't get u...</P><P></P><P>anyways i have found a solution....</P><P></P><P></P><P>Thnx again for ur help.</P></BODY></HTML> Wed, 27 Jul 2011 08:30:52 GMT https://community.qlik.com/t5/QlikView/For-Loop/m-p/309934#M1191359 2011-07-27T08:30:52Z