topic Re: aggr expression in QlikView

aggr expression

Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I have a table which looks like the sample attached.

Sheet ‘Actual data’ is the raw data.

I have to make a pivot table like in sheet ‘Required data’

Each Product ID has multiple Delivery ID and multiple vehicle ID (with order no)

I have to exclude the vehicle ID with order = 0.

Also I have to bring one row of Vehicle ID per product code

I tried the below expression to bring all vehicle id in one cell. But I couldn’t exclude vehicle ID with order = 0

aggr(Concat(distinct [Vehicle ID],', '),ProdCode,DeliveryID)

Can someone please help me with expression..?

kaushiknsolanki — Tue, 20 Dec 2016 10:38:15 GMT

Hi,

Try this,

Concat({<Order = {">0"}>}distinct [Vehicle ID],', ')

Regards,

Kaushik Solanki

sunny_talwar — Tue, 20 Dec 2016 12:56:00 GMT

Is order an expression? May be this:

Concat({<[Vehicle ID] = {"=Count(OrderID) = 0"}>} DISTINCT [Vehicle ID], ', ')

I assumed that your Order is a expression -> Count(OrderID). Replace Count(OrderID) with your actual expression in the above expression