Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Linking Tables with a Condition

Hi

I have 2 excel tables.  The one table is a "Customers Table" and the other is a "Sales Table"

The customer table is as follows:

Customer CodeCustomerCustomer Group
ELS001ElSat - JOHANNESBURGBranch

The Sales table is as follows.

Customer CodeItem CodeQtySales Value
ELS001INSL100100,000
ELS001ABC5025,000
ELS001FEPT6017,000

If we sell Item Code " INSL" to Customer ELS001 , I want the Customer Group to change to , say , "Multichoice" , otherwise the Customer Group must stay as "Branch"

How do I create the scripting for this?

Thanking you in advance.

kind regards

Nayan

2 Replies
maxgro
MVP
MVP

see attachment

Not applicable
Author

Hi Massimo

Thank oyu for your prompt response.  I will try it out and let you know.

kind regards

Nayan