Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
MVP
MVP

Re: Linking Tables with a Condition

see attachment

Not applicable

Re: Linking Tables with a Condition

Hi Massimo

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

kind regards

Nayan

Community Browser