Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ashmitp869
Creator
Creator

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

Hi there ,

In the qlikview script - 

I have restricted cost centre script -

ashmitp869_0-1634099672995.png

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

ashmitp869_1-1634099810995.png

Thanks

 

 

1 Reply
AshutoshBhumkar
Partner
Partner

Hi,

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

E.g Where Exist(CostCentreCode, CostCentre)

 

Thanks,
Ashutosh