topic Problem with script (customer segmentation when relation isn't 1:1) in QlikView

Problem with script (customer segmentation when relation isn't 1:1)

Mon, 12 Oct 2009 21:21:50 GMT

i need help in qV script.
I get an excel file with customer segmentation (relation is 1:1).

client number
Segment

It would'nt be a problem. But...
When the sale is from X activity (we've got 3 other activities) then customer segment is another then in file - is always segment- D
For one client when sale is from y activity -segment should be - c, for rest activities sholud be from file

I have no idea how to do this
Please help me

Problem with script (customer segmentation when relation isn't 1:1)

Mon, 12 Oct 2009 21:47:38 GMT

Hello,

based on the given information I would create a lookup table (most probably in Excel) where only the exceptions are defined (customer,activity,segment). This XL table I would load into QV.

Upon load of the data, I would use the LookUp function to get the mapping.
If LookUp returns Null(), the original (file) value should be used.

After/ at the end of the Load I would drop the lookup table (drop table).

hth,
Thilo