Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
rsundarraj
New 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

Tags (1)
1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Aggregation

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


talk is cheap, supply exceeds demand

View solution in original post

6 Replies
MVP & Luminary
MVP & Luminary

Re: Aggregation

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
Valued Contributor

Re: Aggregation

Hi,

1 option

in the script

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

and expression =SUM(COUNT_DEL)

qlikdeez
Valued Contributor

Re: Aggregation

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
New Contributor III

Re: Aggregation

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

Highlighted
MVP & Luminary
MVP & Luminary

Re: Aggregation

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


talk is cheap, supply exceeds demand

View solution in original post

rsundarraj
New Contributor III

Re: Aggregation

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