Can recno() be used in charts?

[wanyunyang]

Hi guys,

I want to read the number of the currently read row of the current table in chart. But recno() seems to be a script function. Is there a similar one for charts?

[Ksrinivasan]

hi,

yes, but you can use RowNo()

RowNo -scriptfunction ThisfunctionreturnsanintegerforthepositionofthecurrentrowintheresultingQlikSenseinternaltable. Thefirstrowisnumber1. RowNo ( ) RowNo -chartfunction RowNo()returnsthenumberofthecurrentrowwithinthecurrentcolumnsegmentinatable.Forbitmap charts,RowNo() returnsthenumberofthecurrentrowwithinthechart'sstraighttableequivalent.

ksrinivasan

[wanyunyang]

Hello,

Thank you for your reply! But I only want to read the number of the currently read row of the current table (filtered), and rowno() gives result before filtering.

[Ksrinivasan]

hi,

result:

Tab1: LOAD * INLINE [A, B 1, aa 2,cc 3,ee];
Tab2: LOAD * INLINE [C, D 5, xx 4,yy 6,zz];
Loadingrecordandrownumbersforselectedrows:
QTab: LOAD *, RecNo( ), RowNo( ) resident Tab1 where A<>2;
LOAD C as A, D as B, RecNo( ), RowNo( ) resident Tab2 where A<>5;
//We don't need the source tables anymore, so we drop them Drop tables Tab1, Tab2; TheresultingQlikSenseinternaltable:
A B RecNo( ) RowNo( )
1 aa 1 1
3 ee 3 2
4 yy 2 3
6 zz 3 4

ksrinivasan

[wanyunyang]

Oh I see! I mixed recno() and rowno() 😅 Sorry.

But when I add rowno() as a measure in the straight table, results are all 1...

[wanyunyang]

I got it. I should use row(Total)

[Ksrinivasan]

hi,

okey,

are you in japan or china!!!!

ksrinivasan

[wanyunyang]

i'm from china