topic Re: RowNo() alternative in QlikView

RowNo() alternative

dzmitry_shmurye — Wed, 08 Jun 2016 07:48:06 GMT

Hi community!

I am trying to create expression for generate Row numbers in the straight table but without using RowNo() function.

I have tryed to write expression like this:

RangeSum(1,Above(Rows))

But I need generate Rows values only for first fives rows in the table (P1 - P5) and for others rows it's should be Null values in the Rows expression.

Could somebody help me resolve this issue?

Re: RowNo() alternative

Wed, 08 Jun 2016 08:45:35 GMT

Hi,

Will P1 always be 1, P2 always 2 etc or could that change?

Re: RowNo() alternative

dzmitry_shmurye — Wed, 08 Jun 2016 08:48:16 GMT

No, I can select P3-P8 and P3 should have 1, P4 -2 etc like RowNo() function.

Re: RowNo() alternative

Anonymous — Wed, 08 Jun 2016 09:15:39 GMT

Hi Dzmitry,

Try this:

IF(Rank(Total Min(-Num(Purgechar(Product,'P'))))<=5,Rank(Total Min(-Num(Purgechar(Product,'P')))))

Regards

Re: RowNo() alternative

sujeetsingh — Wed, 08 Jun 2016 09:21:44 GMT

I do not know r you facing an issue or you doing an R&D to find another way of doing it.

Re: RowNo() alternative

Digvijay_Singh — Wed, 08 Jun 2016 09:31:00 GMT

try this -

If(rowno()<=5,rangesum(Above([Rows]),1),'-')

Re: RowNo() alternative

Peter_Cammaert — Wed, 08 Jun 2016 09:45:55 GMT

Not the most elegant hack, but it works. This one uses a dummy hidden expression (RowActive)

Best,

Peter

Re: RowNo() alternative

tamilarasu — Wed, 08 Jun 2016 10:02:45 GMT

Or you can try below expression,

If(Isnull(Above(Rows)),1,If(Above(Rows)+1<=5, Above(Rows)+1,'-'))

Re: RowNo() alternative

Peter_Cammaert — Wed, 08 Jun 2016 10:12:36 GMT

Nice one, faking Null values

Re: RowNo() alternative

susovan — Wed, 08 Jun 2016 10:15:39 GMT

It might be work.

if(RowNo()<6,RangeSum(1,Above(Rows)))

Re: RowNo() alternative

dzmitry_shmurye — Wed, 08 Jun 2016 10:30:11 GMT

Thanks, but I need also hide all rows with null values.

Re: RowNo() alternative

dzmitry_shmurye — Wed, 08 Jun 2016 10:43:43 GMT

Thanks, but instead P1, P2 ... could be another values of dimension and only with text.

Re: RowNo() alternative

susovan — Wed, 08 Jun 2016 12:02:03 GMT

Try this attachment file,

Re: RowNo() alternative

Anonymous — Wed, 08 Jun 2016 12:07:23 GMT

Hi Dzimitry, Have you tried my answer?

Thanks.

Re: RowNo() alternative

dzmitry_shmurye — Wed, 08 Jun 2016 12:08:27 GMT

Unfortunately I can't use RowNo() function for this because using the function automatically disabled this checkbox functionallity in 11.2 SR13 version.

Re: RowNo() alternative

dzmitry_shmurye — Wed, 08 Jun 2016 12:10:22 GMT

Yes I gave tried, bur in the dimension field could be any values without "P" and numbers.

Re: RowNo() alternative

Anonymous — Wed, 08 Jun 2016 12:10:55 GMT

Hi Dzimitry, you need change Purgechar(Product,'P') with the real values that defines the order.

Regards

Re: RowNo() alternative

dzmitry_shmurye — Wed, 08 Jun 2016 12:15:59 GMT

Could you please provide example? for: Milk, Bread, Meat ... values of dimension?

Re: RowNo() alternative

Anonymous — Wed, 08 Jun 2016 12:18:37 GMT

How do you will order this dimensions?

Re: RowNo() alternative

dzmitry_shmurye — Wed, 08 Jun 2016 12:20:39 GMT

Load order for example