rowno() is not working?

Wed, 27 Jun 2012 04:37:50 GMT

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:-)

Re: rowno() is not working?

tresB — Wed, 27 Jun 2012 04:45:13 GMT

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

Regards,

tresesco

topic rowno() is not working? in QlikView

rowno() is not working?

Re: rowno() is not working?