Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
NavinReddy
Creator II
Creator II

Help

Hi All,

RecNo not working for me

Could some one help me

Test:

LOAD * INLINE [

RowNoID,

1

2

3

5

6

7

8

];

LET vpeek=Peek('RowNoID',-2);

LOAD *,

RecNo() as recnumber,

RowNo() as rownumber

Resident Test Where RowNoID<>8;

DROP Table Test;

Thanks in Advance

Rohiht

1 Solution

Accepted Solutions
tresesco
MVP
MVP

What is the issue? can you please explain a bit?

PFA, if it helps.

View solution in original post

3 Replies
tresesco
MVP
MVP

it is working. try using RowNoID<>7, you will understand the difference. while you are trying with the RowNoID<>8 then rowno() and recno() would generate same results, might be you are getting confused there.

NavinReddy
Creator II
Creator II
Author

Hi tres

again im getting same issue

help me

Thanks,

rohith

tresesco
MVP
MVP

What is the issue? can you please explain a bit?

PFA, if it helps.