Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
rsundarraj
Contributor III
Contributor III

Aggregation

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

6 Replies
Gysbert_Wassenaar

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"?


talk is cheap, supply exceeds demand
el_aprendiz111
Specialist
Specialist

Hi,

1 option

in the script

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

and expression =SUM(COUNT_DEL)

qlikdeez
Specialist
Specialist

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?

rsundarraj
Contributor III
Contributor III
Author

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

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


talk is cheap, supply exceeds demand
rsundarraj
Contributor III
Contributor III
Author

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