Equivalent of @@ROWCOUNT

[#1]

As in the title - is there an equivalent of SQL @@ROWCOUNT function in QlikView?

Regards,

Przemek

[whiteline]

Hi.

I guess no.

What is the purpose to have it ?

[julian_rodriguez]

You may create a field with the function RowNo()... and then calculate the maximum value of it?

[#4]

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.

WHILE @@ROWCOUNT >0 
UPDATE T
SET Text = REPLACE( T.Text, V.Variable, V.Replacetext)
FROM #Text AS T CROSS JOIN #vars AS V
WHERE T.Text LIKE '%'+V.Variable +'%'

[julian_rodriguez · Accepted solution]

I'm not expert on Transact-SQL... but is it like an Mapping routine?

[#6]

Sure it is 🙂 Rob's Cookbook has perfect example for that. Thanks.