is it possible to do an nexel function based on a different layout on the same screen?
If yes, how?
Thanks and BR
Hi Moritz Funk,
there's the Nexel CrossView functionality that does just that. Here's a link of the help pages Nexel
Are you trying to do something specific?
Ah, thank you: searched in KB and Com, but not there.^^
In addition to this I notify that, as far as I know, the cross view function does not work in multidatabase screens between views linked to different dbs
Hi Ray Martens ,
I have tried to use crossview multiple types by carefully following the Nexel instructions but it never works. It's in the same screen and not referencing other databases. Is there any common mistake I might be making?
Few of the fellow colleagues confirmed that they also have had difficulties with using it.
Hi Edgars Kancans,
I've found out there is one caveat: you can only reference positions within the same range. For example you have two tables. One table/dataview with your nexel function (let's call it target) and one with data you're trying to reference (let's call it source). Target has 10 rows and source only one. If at target you're in row 2, you cannot reference row 2 from source as there is none. You also can't use the possibilities that the range methods of the nexel functions offer - in row 2 you won't get any data from source. What you can do in such a case is add a column (b) in target. In column a you reference source. It might return a result for row 1. In (b) you use a nexel function to reference column (a) from target. In (b) you now are able to use the dynamic range such as 'Range.Up'.
Now this probably does not answer your question. For that I'd need to see a bit what you are doing. Can you post the dataview definitions and the nexel formula(s) you're trying to use?
Thanks Ray Martens for the valuable explanation. I did few tests and concluded that this was the reason why my crossviews failed so often before. For our project we were able to build what we need using Dataflows. Thanks again for your quick response.
Retrieving data ...