topic Re: Custom field dispalyed in QlikView

Custom field dispalyed

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have the following design

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

sunny_talwar — Tue, 26 Apr 2016 10:19:58 GMT

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

avinashelite — Tue, 26 Apr 2016 11:38:48 GMT

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 — Tue, 26 Apr 2016 11:50:17 GMT

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)