topic Re: Aggregation in QlikView

Aggregation

Anonymous — Tue, 18 Oct 2016 10:42:47 GMT

Hi All,

I have Carrier_Code, Delivery Number ,Ship date and Cost.

Some of the Delivery numbers are not are rated or the cost =0.

Now I need the count of Non Rated .

Please provide me aggregation

Gysbert_Wassenaar — Tue, 18 Oct 2016 12:09:33 GMT

Some of the Delivery numbers are not are rated

Now I need the count of Non Rated .

Define "Non Rated". What are the conditions that determine a Delivery Number is "Non Rated"?

el_aprendiz111 — Tue, 18 Oct 2016 12:23:55 GMT

Hi,

1 option

in the script

LOAD *, IF([Delivery Number]=0,1,0) AS COUNT_DEL;

and expression =SUM(COUNT_DEL)

Anonymous — Tue, 18 Oct 2016 12:26:16 GMT

Do you mean that the delivery Number is blank when you say non rated?

Would you like to do it in script or on the front end only?

Can you post sample data perhaps?

Anonymous — Tue, 18 Oct 2016 13:04:23 GMT

Hi,

Not Rated is like :

All the Delivery number should carry a cost.

but some delivery number doesn't have the cost or the cost is 0.

When the cost is 0 it is Non rated.

count(distinct(Delivery))-Aggr(count(distinct ShipDate),Cost,Delivery)

I have written it in a Expression in UI but not sure it is right

Gysbert_Wassenaar — Tue, 18 Oct 2016 13:09:56 GMT

Try this: Count({<Cost={0}>} Distinct [Delivery Number])

Anonymous — Thu, 20 Oct 2016 10:38:20 GMT

yes like to do it in front end .More over the Gysber Wassenaar provided me right answer thanks .