Assigning values to a variable

Mon, 10 Jun 2013 13:52:40 GMT

Hi,

I have the below query which is working fine but its a situation to store the values in a variable and then use in the script but I can not get the actual values because of Customer_Location.

Note * The Customer_No, Customer_Sub has a unique values but the Customer_Location has duplicate values,

Working Code

Select Customer_No,

Customer_Sub,

Customer_Location,

Customer_Name,

Product_Code,

Product_Name,

Qty,

Amount

from table name

Where Customer_No = 500 and Customer_Sub IN(20100,20101) and Customer_Location In(1,3,8,10,15,19,20) or

Customer_No = 600 and Customer_Sub IN(30001,30002) and Customer_Location IN(1,2,4,6,8,11,23,25,27)

Using the Variable

Let vCustomer_No = Pick(Num('500,600'))

Let vCustomer_Sub = Pick(Num('300001,30002'))

Let vCustomer_Loc = Pick(Num('1,3,8,10,15,19,20 ,1,2,4,6,8,11,23,25,27'))

the result data is like this, how to separate the Customer_Loc for the particular Customer_No and Customer_Sub ???

Customer_No	Customer_Sub	Customer_Loc
500	20100,20101	1,2,3,4,6,8,10,11,15,19,20,23,27
600	300001,30002	1,2,3,4,6,8,10,11,15,19,20,23,27

Regards

Chriss

Re: Assigning values to a variable

RedSky001 — Mon, 10 Jun 2013 16:47:57 GMT

Hi Chris,

I don't follow you.

Are you saying you have two data sets. The first contains all your data and the second contains the values you want to filter the first set of data by?

If so can you provide both sets of data and and third table to show the results you are expecting.

topic Re: Assigning values to a variable in QlikView

Assigning values to a variable

Re: Assigning values to a variable