topic Display linenumber in QlikView

Display linenumber

Anonymous — Wed, 16 Dec 2009 20:15:02 GMT

Hello,

I would like to display the linenumber in a view in which within a selected month per date the turnover is displayed. Like this:

1-11-2009 100.000 EURO 1

2-11-2009 50.000 EURO 2

4-11-2009 75.000 EURO 3

I cannot arrange this with rowno(). Because Qlikview handles then also all the lines before 1-11-2009.When I try that the view shows:

....

30-10-2009 0 298

31-10-2009 0 299

1-11-2009 100.000 EURO 300

2-11-2009 50.000 EURO 301

4-11-2009 75.000 EURO 302

Can someone help me?

Thanks in advance

greinier

Display linenumber

Wed, 16 Dec 2009 21:37:38 GMT

Hi,

see the example. Hopefully it contains what you are looking for.

Good luck!

Rainer

Display linenumber

Anonymous — Fri, 18 Dec 2009 15:25:09 GMT

Hello Rainer,

Thanks for your reply. I modified the qvw a bit so the problem is more clear I hope.

As you can see in the view where the rowno is displayed, the rowno starts with 4. It has to start with 1. That's my problem.

Do you have a suggestion ?

Thx.

Greinier

Display linenumber

Fri, 18 Dec 2009 15:51:57 GMT

Hi,

what about a "Dynamic Dimension"?

Rainer

Display linenumber

Anonymous — Fri, 18 Dec 2009 17:29:50 GMT

Hello Rainer,

Do you have a tip how to solve this with a Dynamic Dimension ?

Thx.

Kind regards,

Gert

Display linenumber

Fri, 18 Dec 2009 17:33:20 GMT

Hi,

see the attached application.

There is one ...

Rainer

Display linenumber

Anonymous — Fri, 18 Dec 2009 17:47:13 GMT

Thx. a lot. This is the solution I think.

Regards,

Greinier