Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Lesor
Contributor II
Contributor II

RowNo() returns null values only

Hi,

I'm trying to put an autoNo in the table instead in the load script (due to data size) but when I'm using rowno() or rowno(TOTAL), it only displays null. I'm new to qlik and I don't know what I'm doing wrong.

Lesor_0-1675055642014.png

#new_to_qlikview #rowno #qlikview_creating_analytics

Labels (2)
1 Solution

Accepted Solutions
MayilVahanan

Hi

Try to use RowNo(Total) in Measure instead of Dimension, hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

4 Replies
sidhiq91
Specialist II
Specialist II

@Lesor Can you try something like below, let me know if this is working or not.

NoConcatenate
Temp:
Load Rowno() as Row_Number,
Ref_no
Inline [
Ref_no
1011
2011
3011
4011
5011
6011
];

Exit Script;

sidhiq91_0-1675056636690.png

 

Lesor
Contributor II
Contributor II
Author

Hi Sidhiq91,

Thanks for this, it is working.

But I'm exploring if it is possible to handle this outside the script and in the analyzer only, I have viewed many solutions already and they were able to rowno() just fine. I just don't know why I'm not able to make it work.

MayilVahanan

Hi

Try to use RowNo(Total) in Measure instead of Dimension, hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Lesor
Contributor II
Contributor II
Author

Hi  ,

Thank you very much, this is what I'm looking for.

 

Hi Sidhiq91 ,

Thank you very much as well for helping.