Custom field dispalyed

[Anonymous]

I have the following design

How could I displayed only Code Article related to table Reference ?

[sunny_talwar]

May be when you create those tables, create a flag which can then be used in your set analysis.

[avinashelite]

Add a new filed in the script level and use that field in the front end that will help you to display the values related to particular table

try like this

Reference:

LOAD

[Code Article],

[Code Reference],

'Reference_Table' as Identifier

from table

so in the front end you could add a list box Identifier and select the value or add the filter in the set analysis like

sum({<Identifier={'Reference_Table'}>}Amount)

Hope this helps you

[Kushal_Chawda]

You can go for what Avinash has suggested or alternative to below

Reference:

LOAD [Code Article],

          [Code Reference]

FROM Reference;

Now Load the Vente table

Vente:

LOAD *,

          if(exists([Code Article],[Code Article]),1,0) as Flag

FROM venta;

Now put the Flag condition in all your expression

Sum({<Flag={'1'}>}Amount)