Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
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