RowNo() returns null values only

[Lesor]

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.

#new_to_qlikview #rowno #qlikview_creating_analytics

[sidhiq91]

@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;

[Lesor]

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 · Accepted solution]

Hi

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

[Lesor]

Hi MayilVahanan ,

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

Hi Sidhiq91 ,

Thank you very much as well for helping.