topic Re: Dynamic Row No in Table in QlikView

Dynamic Row No in Table

Tue, 20 May 2014 05:46:34 GMT

Hi All,

Thanks a lot for your help and support. I have a query . I wanted to insert row no in table below like 1,2,3 ,etc I tried rowno() function but it is not working

Can anyone please help me on this?

Thanks a lot for your help

Re: Dynamic Row No in Table

nizamsha — Tue, 20 May 2014 05:51:22 GMT

Rowno(Total) in ur expression

and check no total then bring the rowno(total) as First column by dragging

Re: Dynamic Row No in Table

nizamsha — Tue, 20 May 2014 05:52:41 GMT

PFA

Re: Dynamic Row No in Table

Tue, 20 May 2014 06:02:47 GMT

I added RowNo(TOTAL) to expression and moved the column to first. Its working only issue is that its showing 0 in total row.

can we show it blank or total no of rows in table ?

Many thanks for your help

Re: Dynamic Row No in Table

nizamsha — Tue, 20 May 2014 06:11:21 GMT

uncheck in expression tab->Total Mode-> Check no total

or see the file i have attached

Re: Dynamic Row No in Table

Tue, 20 May 2014 06:15:04 GMT

Thanks its working fine