Discussion Board for collaboration related to QlikView App Development.
I have a table with a list of customers with a certain quantity.
In another table there are ranges of quantities in order to assign each customer to a cluster (low, medium..., high).
I found a solution (in attach, with data), but I would like to know if there are smarter ways, considering that I have a large amount of data to deal with (I suppose my join is not the best solution).
FROM Dati2.xlsx (ooxml, embedded labels, table is Sheet2);
FROM Dati2.xlsx (ooxml, embedded labels, table is Sheet1);
INNER JOIN (CLUSTER) IntervalMatch (QUANTITY, KEY) LOAD MIN, MAX, KEY RESIDENT CLUSTER;
Thank you very much! but I need a datamodel with just one table with fields CUSTOMER and CLUSTER (as in my solution)... Is it possible?
A work around...
INNER JOIN (CLUSTER) IntervalMatch (QUANTITY, KEY) LOAD Distinct MIN, MAX, KEY RESIDENT CLUSTER;
LOAD QUANTITY & KEY,
ApplyMap('ClusterMap', QUANTITY & KEY, Null()) as CLUSTER
DROP Table FASCE, CLUSTER;
The problem is that QUANTITY is a float number with 5 decimal and KEY can have many values... I don't know if performance is better than other solutions.
Someone has other solutions?