Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
see the example. Hopefully it contains what you are looking for.
Good luck!
Rainer
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
Hi,
what about a "Dynamic Dimension"?
Rainer
Hello Rainer,
Do you have a tip how to solve this with a Dynamic Dimension ?
Thx.
Kind regards,
Gert
Hi,
see the attached application.
There is one ...
Rainer
Thx. a lot. This is the solution I think.
Regards,
Greinier