topic Re: need help in QlikView https://community.qlik.com/t5/QlikView/need-help/m-p/503908#M1123450 <HTML><HEAD></HEAD><BODY><P>If you use the script above it creates a table that contains Chennai 11 times.</P></BODY></HTML> Tue, 14 Jan 2014 06:40:32 GMT whiteline 2014-01-14T06:40:32Z need help https://community.qlik.com/t5/QlikView/need-help/m-p/503905#M1123447 <HTML><HEAD></HEAD><BODY><P>hi please help me in this </P><P></P><P></P><P>if i click on the chennai city i should get 11 times chennai city in separate table and same for the remaining citys also can u tel me how to solve that problem </P></BODY></HTML> Tue, 14 Jan 2014 04:36:33 GMT https://community.qlik.com/t5/QlikView/need-help/m-p/503905#M1123447 2014-01-14T04:36:33Z Re: need help https://community.qlik.com/t5/QlikView/need-help/m-p/503906#M1123448 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>Maybe like this:</P><P>&nbsp; </P><P><STRONG><SPAN lang="EN-US" style="color: blue; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;">LOAD</SPAN></STRONG> <SPAN lang="EN-US" style="color: maroon; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;">cityno</SPAN><SPAN lang="EN-US" style="color: black; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;">, <BR />&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN lang="EN-US" style="color: maroon; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;">city</SPAN><SPAN lang="EN-US" style="color: black; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;">, <BR />&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN lang="EN-US" style="color: maroon; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;">product</SPAN><SPAN lang="EN-US" style="color: black; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;"><BR /><SPAN lang="EN-US" style="color: blue; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;">FROM</SPAN><SPAN lang="EN-US" style="color: black; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;"><BR />[wrk12.xlsx]<BR />(</SPAN><SPAN lang="EN-US" style="color: blue; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;">ooxml</SPAN><SPAN lang="EN-US" style="color: black; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;">, </SPAN><SPAN lang="EN-US" style="color: blue; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;">embedded</SPAN> <SPAN lang="EN-US" style="color: blue; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;">labels</SPAN><SPAN lang="EN-US" style="color: black; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;">, </SPAN><SPAN lang="EN-US" style="color: blue; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;">table</SPAN> <SPAN lang="EN-US" style="color: blue; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;">is</SPAN><SPAN lang="EN-US" style="color: black; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;"> Sheet1)<BR /><SPAN lang="EN-US" style="color: blue; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;">while</SPAN> <SPAN lang="EN-US" style="color: blue; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;">IterNo</SPAN><SPAN lang="EN-US" style="color: black; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;">()&lt;=</SPAN><SPAN lang="EN-US" style="color: maroon; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;">cityno</SPAN><SPAN lang="EN-US" style="color: black; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;">; </SPAN></SPAN></SPAN></P><P></P><P></P></BODY></HTML> Tue, 14 Jan 2014 05:59:56 GMT https://community.qlik.com/t5/QlikView/need-help/m-p/503906#M1123448 whiteline 2014-01-14T05:59:56Z Re: need help https://community.qlik.com/t5/QlikView/need-help/m-p/503907#M1123449 <HTML><HEAD></HEAD><BODY><P>i should get Chennai 11 times in another table&nbsp; ,can u tell me how to do </P></BODY></HTML> Tue, 14 Jan 2014 06:11:00 GMT https://community.qlik.com/t5/QlikView/need-help/m-p/503907#M1123449 2014-01-14T06:11:00Z Re: need help https://community.qlik.com/t5/QlikView/need-help/m-p/503908#M1123450 <HTML><HEAD></HEAD><BODY><P>If you use the script above it creates a table that contains Chennai 11 times.</P></BODY></HTML> Tue, 14 Jan 2014 06:40:32 GMT https://community.qlik.com/t5/QlikView/need-help/m-p/503908#M1123450 whiteline 2014-01-14T06:40:32Z