topic Re: Using fields with TOTAL qualifier in RowNo() in QlikView

Using fields with TOTAL qualifier in RowNo()

slaheddinekeyru — Wed, 15 Nov 2017 09:11:34 GMT

Hello Community,

I'm using the RowNo() function when loading a table in my script.

I need the TOTAL qualifier to create a RowNo by field block. So I have to write this

test1:

LOAD

RecNo(),

RowNo(TOTAL<Group>) as Rowno

Resident test

;

But it's not working.

I will be very gratefull if you have any idea.

Thank you very much for reading my discussion.

SME.

shraddha_g — Wed, 15 Nov 2017 09:13:28 GMT

Can you elaborate more with sample data and expected output?

sunny_talwar — Wed, 15 Nov 2017 09:15:41 GMT

May be try this

AutoNumber(RowNo(), Group) as RowNoByGroup

or this

If(Group = Previous(Group), RangeSum(Peek('RowNoByGroup'), 1), 1) as RowNoByGroup

In both cases, make sure that your data is correctly sorted (if it is not already sorted) by using a resident load with order by clause

slaheddinekeyru — Wed, 15 Nov 2017 09:27:06 GMT

Thank you very much stalwar1‌

That's exactly what I'm looking for.

But I don't understand why we can't use the TOTAL qualifier with RowNo() ?

sunny_talwar — Wed, 15 Nov 2017 09:27:57 GMT

TOTAL qualifier is not available in the script... this is by design...