where clause in qvd from prev loaded cost centre from another table ?

[ashmitp869]

Hi there ,

In the qlikview script - 

I have restricted cost centre script -

Can I only load cost centre which is present in CCWarMapping in the below table with out hard code  -

Thanks

[AshutoshBhumkar]

Hi,

You can use Exist() function to take only Cost Centres present in CCWarMapping table.

E.g Where Exist(CostCentreCode, CostCentre)

Thanks,
Ashutosh