Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Display linenumber

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

Labels (1)
6 Replies
Not applicable
Author

Hi,

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

Good luck!

Rainer

Anonymous
Not applicable
Author

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

Not applicable
Author

Hi,

what about a "Dynamic Dimension"?

Rainer

Anonymous
Not applicable
Author

Hello Rainer,

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

Thx.

Kind regards,

Gert

Not applicable
Author

Hi,

see the attached application.

There is one ...

Rainer

Anonymous
Not applicable
Author

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

Regards,

Greinier