Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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

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