topic Re: Equivalent of @@ROWCOUNT in QlikView https://community.qlik.com/t5/QlikView/Equivalent-of-ROWCOUNT/m-p/590483#M682429 <HTML><HEAD></HEAD><BODY><P>Sure it is <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> Rob's Cookbook has perfect example for that. Thanks.</P></BODY></HTML> Wed, 19 Mar 2014 08:34:27 GMT 2014-03-19T08:34:27Z Equivalent of @@ROWCOUNT https://community.qlik.com/t5/QlikView/Equivalent-of-ROWCOUNT/m-p/590478#M682422 <HTML><HEAD></HEAD><BODY><P>As in the title - is there an equivalent of SQL @@ROWCOUNT function in QlikView?</P><P></P><P>Regards,</P><P>Przemek</P></BODY></HTML> Tue, 18 Mar 2014 20:36:33 GMT https://community.qlik.com/t5/QlikView/Equivalent-of-ROWCOUNT/m-p/590478#M682422 2014-03-18T20:36:33Z Re: Equivalent of @@ROWCOUNT https://community.qlik.com/t5/QlikView/Equivalent-of-ROWCOUNT/m-p/590479#M682423 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>I guess no.</P><P>What is the purpose to have it ? </P></BODY></HTML> Tue, 18 Mar 2014 20:48:05 GMT https://community.qlik.com/t5/QlikView/Equivalent-of-ROWCOUNT/m-p/590479#M682423 whiteline 2014-03-18T20:48:05Z Re: Equivalent of @@ROWCOUNT https://community.qlik.com/t5/QlikView/Equivalent-of-ROWCOUNT/m-p/590480#M682424 <HTML><HEAD></HEAD><BODY><P>You may create a field with the function RowNo()... and then calculate the maximum value of it?</P></BODY></HTML> Tue, 18 Mar 2014 20:50:06 GMT https://community.qlik.com/t5/QlikView/Equivalent-of-ROWCOUNT/m-p/590480#M682424 julian_rodriguez 2014-03-18T20:50:06Z Re: Re: Equivalent of @@ROWCOUNT https://community.qlik.com/t5/QlikView/Equivalent-of-ROWCOUNT/m-p/590481#M682426 <HTML><HEAD></HEAD><BODY><P>I need to apply tens of replace statements to clean text. For that, I've got the below SQL script but would like to transfer it to QV. I've tried with peek loops but with no success. If I'd nest the replace statements, I'd end up with something like a meter long script line.</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="_jivemacro_uid_13951760092241894 jive_text_macro jive_macro_code" jivemacro_uid="_13951760092241894"> <P>WHILE @@ROWCOUNT &gt;0 </P> <P>UPDATE T</P> <P>SET Text = REPLACE( T.Text, V.Variable, V.Replacetext)</P> <P>FROM #Text AS T CROSS JOIN #vars AS V</P> <P>WHERE T.Text LIKE '%'+V.Variable +'%'</P> </PRE></BODY></HTML> Tue, 18 Mar 2014 20:58:24 GMT https://community.qlik.com/t5/QlikView/Equivalent-of-ROWCOUNT/m-p/590481#M682426 2014-03-18T20:58:24Z Re: Equivalent of @@ROWCOUNT https://community.qlik.com/t5/QlikView/Equivalent-of-ROWCOUNT/m-p/590482#M682427 <HTML><HEAD></HEAD><BODY><P>I'm not expert on Transact-SQL... but is it like an Mapping routine?</P></BODY></HTML> Tue, 18 Mar 2014 21:01:19 GMT https://community.qlik.com/t5/QlikView/Equivalent-of-ROWCOUNT/m-p/590482#M682427 julian_rodriguez 2014-03-18T21:01:19Z Re: Equivalent of @@ROWCOUNT https://community.qlik.com/t5/QlikView/Equivalent-of-ROWCOUNT/m-p/590483#M682429 <HTML><HEAD></HEAD><BODY><P>Sure it is <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> Rob's Cookbook has perfect example for that. Thanks.</P></BODY></HTML> Wed, 19 Mar 2014 08:34:27 GMT https://community.qlik.com/t5/QlikView/Equivalent-of-ROWCOUNT/m-p/590483#M682429 2014-03-19T08:34:27Z