Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Equivalent of @@ROWCOUNT

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

Regards,

Przemek

1 Solution

Accepted Solutions
julian_rodrigue
Valued Contributor

Re: Equivalent of @@ROWCOUNT

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

5 Replies
whiteline
Honored Contributor II

Re: Equivalent of @@ROWCOUNT

Hi.

I guess no.

What is the purpose to have it ?

julian_rodrigue
Valued Contributor

Re: Equivalent of @@ROWCOUNT

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

Not applicable

Re: Re: Equivalent of @@ROWCOUNT

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_rodrigue
Valued Contributor

Re: Equivalent of @@ROWCOUNT

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

Not applicable

Re: Equivalent of @@ROWCOUNT

Sure it is :-) Rob's Cookbook has perfect example for that. Thanks.

Community Browser