topic Re: Create number of rows based on value from column in QlikView https://community.qlik.com/t5/QlikView/Create-number-of-rows-based-on-value-from-column/m-p/1244073#M394731 <HTML><HEAD></HEAD><BODY><P>‌Exactly! Thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 14 Nov 2016 10:20:33 GMT Anonymous 2016-11-14T10:20:33Z Create number of rows based on value from column https://community.qlik.com/t5/QlikView/Create-number-of-rows-based-on-value-from-column/m-p/1244071#M394729 <HTML><HEAD></HEAD><BODY><P>HI all!</P><P></P><P>I am wondering how to create table like below:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Type</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Number</TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">3</TD></TR></TBODY></TABLE><P>‌</P><P></P><P>when we have table like below:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">TYpe</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Number</TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">3</TD></TR></TBODY></TABLE><P></P><P></P><P>Many thanks</P></BODY></HTML> Mon, 14 Nov 2016 10:01:00 GMT https://community.qlik.com/t5/QlikView/Create-number-of-rows-based-on-value-from-column/m-p/1244071#M394729 Anonymous 2016-11-14T10:01:00Z Re: Create number of rows based on value from column https://community.qlik.com/t5/QlikView/Create-number-of-rows-based-on-value-from-column/m-p/1244072#M394730 <HTML><HEAD></HEAD><BODY><P>Hi Thomas,</P><P>maybe</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><STRONG style="font-size: 10pt;">Load</STRONG></SPAN><SPAN style="font-size: 10pt;"> *,<SPAN style="color: #0000ff;">IterNo</SPAN>() <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #800000;">CountID</SPAN> <SPAN style="color: #0000ff;">Inline</SPAN> <SPAN style="color: #800000;">[<BR /> ID,Value<BR /> A,3<BR /> B,4<BR /> C,3<BR /> D,5<BR /> ]</SPAN><BR /> <SPAN style="color: #0000ff;">While</SPAN> <SPAN style="color: #0000ff;">IterNo</SPAN>() &lt;= <SPAN style="color: #800000;">Value</SPAN></SPAN><SPAN style="font-size: 10pt;">; </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Regards,</SPAN></P><P><SPAN style="font-size: 10pt;">Antonio</SPAN></P></BODY></HTML> Mon, 14 Nov 2016 10:09:57 GMT https://community.qlik.com/t5/QlikView/Create-number-of-rows-based-on-value-from-column/m-p/1244072#M394730 antoniotiman 2016-11-14T10:09:57Z Re: Create number of rows based on value from column https://community.qlik.com/t5/QlikView/Create-number-of-rows-based-on-value-from-column/m-p/1244073#M394731 <HTML><HEAD></HEAD><BODY><P>‌Exactly! Thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 14 Nov 2016 10:20:33 GMT https://community.qlik.com/t5/QlikView/Create-number-of-rows-based-on-value-from-column/m-p/1244073#M394731 Anonymous 2016-11-14T10:20:33Z