topic Re: row number in QlikView

row number

Anonymous — Mon, 04 Aug 2014 11:49:34 GMT

hi,

i have strighat table.

is it possible to add in calculete dimension - row number ?

i need to show number for every row -

...

thanks'

yarin.

Re: row number

Mon, 04 Aug 2014 11:52:50 GMT

Hi,

It is better to add it as an expression. Then you can just drag the Column in the Table using the mouse to the first place. It is not possible in a Pivot table though.

Re: row number

amit_saini — Mon, 04 Aug 2014 11:53:45 GMT

Yarin,

Try this:

RowNo() as [Serial Number]

Thanks,

Re: row number

maxgro — Mon, 04 Aug 2014 12:19:53 GMT

may be

aggr(rowno(total), dim1, dim2, ....., dimn)

Re: row number

Anonymous — Mon, 04 Aug 2014 12:22:58 GMT

hi,

where i need to write it ?

Re: row number

aveeeeeee7en — Mon, 04 Aug 2014 12:25:20 GMT

use rowno(total) in your chart expression.

After doing this, drag this expression to the front by holding it's label.

Regards

Aviral Nag

Re: Re: row number

Mon, 04 Aug 2014 12:30:41 GMT

Hi,

It is better to add it as an expression. Then you can just drag the Column in the Table using the mouse to the first place. It is not possible in a Pivot table though.

Re: row number

maxgro — Mon, 04 Aug 2014 12:30:51 GMT

calculated dimension

Re: row number

sudeepkm — Mon, 04 Aug 2014 12:40:23 GMT

As Syed suggested as one expression as RowN0() to your Straight Table.

You can keep the label as Serial No. This way you can have each row in your straight table a number.

Straight table also allows dragging a column name to the left in that case the Serial Number can be the first column in your straight table.

Re: row number

Anonymous — Mon, 04 Aug 2014 13:14:15 GMT

hi,

thank you all, now i get another problem

the row num apear for all my dimention.

my table show only custumer with obligo greather than 0.

after i add the new exp. RowNo(Total) - all my custumer apear.

i try this -

if(obligo>0,RowNo(Total),0)

this isn't solve my problem.

need your help.

thanks'

yarin