topic Re: Possible getting "RowNo()" of a dimension?!? in QlikView

Possible getting "RowNo()" of a dimension?!?

Anonymous — Sun, 27 Nov 2016 09:57:39 GMT

I have a question concerning "dual()-dimensions". I'd just like to use 1 dimension and 1 expression.

Scripting and hidden dimensions (hidden column...) are not an option.

My sample Input:

TABLE:
LOAD * INLINE [
client, sales
1, 5
2, 9
3, 60
4, 50
5, 10
6, 40
6, 40
7, 3
8, 120
9, 1
9, 3
];

Then I have a simple diagram with one dimension and one expression like that:

By using dual() within dynamic dimensions, I can achieve the following result:

Now my question: Is it possible to get the following result by just changing '?' to a dynamic expression:

I tried RowNo() and aggr() combinations without success.

Frank_Hartmann — Sun, 27 Nov 2016 11:31:59 GMT

Hi Robin,

have a look at the attached sample.

As dimension try using this formula:

=aggr(rank(sum(sales)),client)

hope this helps

Anonymous — Sun, 27 Nov 2016 12:09:31 GMT

thanks!

this idea is so simple and very good, just using the rank of the expression as dimension.

I only focused the RowNo() function...