topic Re: row number in QlikView

row number

Thu, 13 Aug 2015 08:59:05 GMT

hi all

I want to put in a straight table numbers for each row (1,2)

- I tried rowno() and rowno(TOTAL) but the problem is that in the expressions used in the table I excluded with set analysis couple of things from all base and row() put me all not only the selections set by me

- rank in not good because is depending from an expression and when I sort different the numbers will mix; more than that, if there are 2 2 things in dimension with the same value rank will repeat number

thanks

Cosmin

Re: row number

sunny_talwar — Thu, 13 Aug 2015 09:02:25 GMT

Have not tested this, but try this may be:

If(YourExpression1 > 0 and YourExpression2 > 0 and YourExpression3 > 0, RowNo())

Re: row number

Thu, 13 Aug 2015 09:12:03 GMT

it is not working

thank you

Re: row number

sunny_talwar — Thu, 13 Aug 2015 09:15:25 GMT

What exactly are you trying to get??

If this is the sample data

Dim Value

A 10

B 20

C 30

In your straight table you want to see A and C and another expression for RowNo like this????

Dim Value RowNo

A 10 1

C 30 2

Re: row number

Thu, 13 Aug 2015 09:21:13 GMT

yes

like this:

A apple 5

A peach 7

B apple 10

B apple 12

B peach 1

C apple 4

D peach 10

and I want to make a straignt table like this:

just for apple (whith set analysis)

Dim Sum (apple) Rownum

A 5 1

B 22 2

C 4 3

with simple rowno() appears also D 4

Re: row number

sunny_talwar — Thu, 13 Aug 2015 09:25:56 GMT

I am seeing this with your sample, this is not what you want?

Re: row number

Thu, 13 Aug 2015 10:15:22 GMT

yes

Re: row number

sunny_talwar — Thu, 13 Aug 2015 10:16:55 GMT

What do you want then???

Re: row number

sasiparupudi1 — Thu, 13 Aug 2015 11:11:44 GMT

Please see the attachement and rowno(TOTAL) seems to be giving the correct values.Is it possible to upload your application?

Sasi

Re: row number

Thu, 13 Aug 2015 12:00:43 GMT

I need this but to work without selection; I see in your ex I need to select 'peach'

thanks

Re: row number

sasiparupudi1 — Thu, 13 Aug 2015 12:24:38 GMT

This?

Re: row number

Thu, 13 Aug 2015 12:32:39 GMT

appears both without selection

like this:

Dim Sum (apple) Rownum

A 5 1

B 22 2

C 4 3

without D because it doesn't have apple; and A,B,C only for apple figures

Re: row number

sasiparupudi1 — Thu, 13 Aug 2015 12:38:33 GMT

ok Please try this

Re: row number

Thu, 13 Aug 2015 13:40:44 GMT

you attached something?

many thanks

Re: row number

sasiparupudi1 — Thu, 13 Aug 2015 14:06:18 GMT

no,the expression is different. It is set to only show apple irrespective of the selections of the fruit list box