topic How to call the values in QlikView

How to call the values

Fri, 31 Dec 2010 11:04:43 GMT

Dear all

I have two tables like Product,Customer

Product table is

CustID CustName ProdID

1 XXXXX 1

2 YYYYY 2,4,6

3 jjjjjjjjjj 2,9

5 kkkkkk 1,9

Customer table contains

ProdID Prod

1 gggggg

2 asaa

3 jkkllllll

upto 10 records.......

I want to calculate, number of customer having this Product..

i.e., count (customer) in y-axis and products as the dimension(X-axis)..

ProductID is upto 1-10(fixed)..

could anyone help me..

how to do this one....

thanks in advance..

How to call the values

Miguel_Angel_Baeyens — Fri, 31 Dec 2010 11:49:00 GMT

Hello,

Use something like the following script to get each customer with only one product

Data:LOAD * INLINE [CustID, CustName, ProdID1, XXXXX, '1'2, YYYYY, '2,4,6'3, jjjjjjjjjj, '2,9'5, kkkkkk, '1,9']; Products:NOCONCATENATE LOAD CustID, CustName, SubField(ProdID, ',') AS ProdIDRESIDENT Data; DROP TABLE Data;

Hope this helps

How to call the values

Mon, 03 Jan 2011 06:18:17 GMT

Hi Miguel,

subfield function is working fine...

but when i use the subfield function,the single row repeated many times based on the values in the ProdID field...

Is there any other way to do this without splitting the rows...

thnx for ur help...