Nexel crossview : Copy all rows from dataview A to dataview B ?

Julien CARDON
Julien CARDON Customer
Fourth Anniversary 100 Comments 25 Likes Level 100: Foundations of Building in Board
in Platform

Hello

Do you know if it is possible to paste value from dataview A to dataview B using Nexel Crossview ? Just copy / paste all values row by row.

I'm trying to use this formula but with no sucess :

=[#A;@a;*;Range.Vertical]

=[#A;@a;*;*]

Also should I use single formula or deep formula ?

image.png

thanks

julien

Answers

  • Samson Sunny
    Samson Sunny Employee, Community Captain
    25 Answers 100 Comments Third Anniversary 25 Likes

    Hi @Julien CARDON ,

    Both the "Single" and the "Deepest Entity" formula should work. Make sure that the dataview that you are referencing in the formula has the layout title. So as per your formula the layout title for Dataview A should have the layout title as "A".

    Also another thing that you could try is to refresh the screen when in play mode. I have often had to refresh the screen to get the Nexel calculations working.

  • Julien CARDON
    Julien CARDON Customer
    Fourth Anniversary 100 Comments 25 Likes Level 100: Foundations of Building in Board

    Thanks for the trick about the double refresh to get nexel applied

    I found the issue : It seems that nexel crossview does not work if a rule is set on another block of dataview B

  • Maik Burghardt
    Maik Burghardt Customer
    10 Comments First Answer 5 Likes First Anniversary
    edited June 10

    Hi, I would like to do something similar. I want to point to the total of a block in another Dataview.

    Is that possible? I cannot get to work so far.

    Is there a more detailed explanation somewhere?

  • Remo Bollhalder
    Remo Bollhalder Employee
    Third Anniversary 5 Answers 10 Comments 5 Up Votes

    Hi @Maik Burghardt

    Your specific case is in the example of the boardmanual. Link (Nexel Crossview): https://www.boardmanual.com/2023/summer/capsules/screens/objects/data-view/nexel-data-view.htm?rhsearch=nexel&rhhlterm=nexel

    I have found cross view to be quite fragile and a lack of error messages make it difficult to use. If you have trouble to make it work, feel free to share your Data View Layouts and Nexel formulas.

  • Maik Burghardt
    Maik Burghardt Customer
    10 Comments First Answer 5 Likes First Anniversary

    Hi, I just tried to achieve what Julien asked.

    it works for the first column

    image.png

    the second column worked once when I hit the refresh button multiple times.

    the third column doesn't refresh at all.

    Since I am trying to show an algorithm from other Data-Views, I am not able to push that into a cube, or?

    Thanks

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    500 Comments 250 Likes Fourth Anniversary 25 Answers

    Hi @Maik Burghardt ,

    you can always push the results of a Nexel calculation into a cube by using the write-back option in Nexel. This will make the action available in procedures, as well.

    Best
    Helmut

Categories