topic Re: RowNo() returns null values only in QlikView

RowNo() returns null values only

Lesor — Mon, 30 Jan 2023 05:16:31 GMT

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

Re: RowNo() returns null values only

sidhiq91 — Mon, 30 Jan 2023 05:30:46 GMT

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

Re: RowNo() returns null values only

Lesor — Mon, 30 Jan 2023 05:50:21 GMT

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.

Re: RowNo() returns null values only

MayilVahanan — Mon, 30 Jan 2023 06:07:13 GMT

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

Re: RowNo() returns null values only

Lesor — Mon, 30 Jan 2023 06:23:18 GMT

Hi MayilVahanan ,

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

Hi Sidhiq91 ,

Thank you very much as well for helping.