topic Problem using concat() in QlikView

Problem using concat()

Mon, 28 Jun 2010 13:43:01 GMT

Hello,

I'm trying to get an overview of how our orders are looking when they are being delivered from more than one warehouse.

I have created a bar chart that uses the following settings:

Dimension= Concat(DISTINCT Warehouse_Id,';')

Expression= Count (DISTINCT Order_Number)

My problem is that when I look at my chart I only get one bar that contain all variants of my dimension.

How can I make QV understand that I want one bar per combination of warehouse_id?

The result should look someting like this:
Warehouse 1 and 2 = 15%
Warehouse 1 and 3 = 25%
Warehouse 2 and 3 = 60%

br
Martin

Problem using concat()

fernandotoledo — Mon, 28 Jun 2010 15:25:00 GMT

You should try to solve this in the script as loading the data.

You can create a dimension concatenating all warehouses that delivers the same order in the same row. This will keep all possible combinations of warehouse and can be used in any chart.

Something like:

LOAD DISTINCT
 ORDER_ID,
 IF(
 ORDER_ID=PREVIOUS(ORDER_ID),
 PEEK("WAREHOUSE_GROUP_ID") & ' and ' & WHAREHOUSE_NAME,
 WHAREHOUSE_NAME
 ) as WAREHOUSE_GROUP
RESIDENT ORDERS
ORDER BY ORDER_ID
;

Then try to find a way to filter the last row for each Order.

Best regards,

Fernando