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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

rowno() is not working?

Hi,

I knew it's a simple script.. but stil it's not working.. any one can explain me clearly pls?

This one is "working" with condition where rowno()<3;

t1:

LOAD * INLINE [

    name.1, id.1

    mani, 1

    maran, 2

    nice, 3

    usa, 4

    ram, 5

    uma, 6

    mani,90

 

] WHERE rowno()<3;

This one is "not working" with condition where rowno()>3;

t2:

LOAD * INLINE [

    name.2, id.2

    mani, 1

    maran, 2

    nice, 3

    usa, 4

    ram, 5

    uma, 6

    mani,90

 

] WHERE rowno()>3;

This one is "not working" with condition where rowno()=3;

t3:

LOAD * INLINE [

    name.3, id.3

    mani, 1

    maran, 2

    nice, 3

    usa, 4

    ram, 5

    uma, 6

    mani,90

 

] WHERE rowno()=3;

The thing is "The function is not working if i use ">" and "=" symbol..

Pls help me with this:-)

Labels (1)
1 Reply
tresB
Champion III
Champion III

I think you need to use Recno(), instead.

Regards,

tresesco