topic Re: RowNo as an Expression or Calculated Dimension in QlikView

RowNo as an Expression or Calculated Dimension

slondono — Tue, 05 Jan 2016 16:16:09 GMT

Hi guys.

I was wondering if I can use RowNo() in an expression or calculated dimension. I have seen examples of this but they always used directly in the script, the point is I'm new in QlikView and even dare not touch the data model I have in charge.

How I can use RowNo in a table to generate a consecutive numeric ? or is it not possible?

Thanks to all

Re: RowNo as an Expression or Calculated Dimension

Anonymous — Tue, 05 Jan 2016 17:14:57 GMT

Hello!

In a Straight Table, you can use RowNo() as an Expression, generating a consecutive numeric.

Hope it helps.

Gabriel

Re: RowNo as an Expression or Calculated Dimension

sunny_talwar — Tue, 05 Jan 2016 17:16:50 GMT

It is possible. If you have a single dimension, then RowNo() and with Multiple Dimensions you can use RowNo(TOTAL)

Re: RowNo as an Expression or Calculated Dimension

Anonymous — Tue, 05 Jan 2016 17:32:25 GMT

hi sebastian,

Yes its possible to generate a consecutive numeric, In a Straight Table, Using RowNo() as an Expression.

first create a expression in Straight table properties - > expression tab , Next type RowNo() in definition.

select option expression total or max rows under total mode as per your requirement

Re: RowNo as an Expression or Calculated Dimension

slondono — Tue, 05 Jan 2016 18:12:08 GMT

Thanks to all. Its working . And sorry for this noob questions

Sunny T's solution is working too.