topic Re: Re: Last RowNo() in QlikView

Last RowNo()

aveeeeeee7en — Thu, 24 Apr 2014 19:18:47 GMT

Hi Community

I have one Question on Rowno()

It is very easy to do calculations based on first Row by using If(Rowno()=1,Your expression)

Suppose if i want last row, what i would write in Expresssion:

if(Rowno()=?,Your expression)

What to write in Place of ?

Regards

Aviral

Re: Last RowNo()

Thu, 24 Apr 2014 19:44:12 GMT

Nag,

i think, you may for example:

a) load your table with additional field = rowno()

next you may load the same table resident but order your data by this additional field descending.

in 2'nd step your last row will be first

Re: Last RowNo()

jerem1234 — Thu, 24 Apr 2014 19:53:28 GMT

I think maybe:

If(Rowno()=NoOfRows(),Your expression)

Hope this helps!

Re: Last RowNo()

sundarakumar — Thu, 24 Apr 2014 19:58:01 GMT

U should use peek in this case.

lets say u have loaded the table as table1 and rowno() as rownumber.

use peek like

let variable1=peek('rownumber',-1,'table1');

now use a resident and use the variable1...

-1 denotes last row in the table(property of (peek)

0 represents 1sr row, 1 represents second.....

Hope this helps.

-Sundar

Re: Re: Last RowNo()

aveeeeeee7en — Thu, 24 Apr 2014 20:04:03 GMT

Can you help me in the Attached Qvw.

Any Help would be Appreciated.

Regards

Aviral

Re: Last RowNo()

jerem1234 — Thu, 24 Apr 2014 20:36:22 GMT

Not sure what kind of sorting you are doing in your original table. Can you explain your logic of how you want to calculate your numbers? what kind of output are you looking for?

I can give you this:

=if(rowno()=NoOfRows(),Count(DISTINCT if(TrnType='MOB',CommonEmpCode)),below([Opening MOB]))

but it does not replicate the values in your original table, since they aren't in the reverse order. To figure out what formula you need, you need to figure out what kind of sorting you have in the table. Not sure if you'll be able to use above, below, rowno(). You might have to do something in the script.

Hope this helps!

Re: Re: Last RowNo()

aveeeeeee7en — Thu, 24 Apr 2014 20:57:56 GMT

I want this:

Re: Logic

Re: Re: Re: Last RowNo()

jerem1234 — Fri, 25 Apr 2014 13:02:59 GMT

If thats the case, then the formula I gave you should work:

=if(rowno()=NoOfRows(),Count(DISTINCT if(TrnType='MOB',CommonEmpCode)),below([Opening MOB]))

Please find attached.