topic Re: Count the Sum greater than zero in QlikView

Count the Sum greater than zero

Tue, 24 Feb 2015 14:52:21 GMT

I have an expression that works: count({$<TotalCharges={'>0'}>} DISTINCT Customer_ID)

The only problem is, there are possible occurrences where the TotalCharges for a Customer_ID is posted and then backed out of the system by posting a negative. Because of this, I'd like to count only the distinct Customer_IDs that have net positive TotalCharges.

I have attempted:

sum(aggr(count({$<TotalCharges={'>0'}>} DISTINCT Customer_ID),AcctPeriod))

where AcctPeriod is my only dimension in the chart, with no avail.

Any help is greatly appreciated, I'm obviously novice trying to pick up on things as quick as possible.

Re: Count the Sum greater than zero

Miguel_Angel_Baeyens — Tue, 24 Feb 2015 14:55:16 GMT

Hi John,

Did you try?

Count({< TotalCharges = {"=Sum(TotalCharges) > 0"} >} DISTINCT Customer_ID)

Miguel

Re: Count the Sum greater than zero

Tue, 24 Feb 2015 15:02:12 GMT

Thank you so much Miguel! I am fairly certain this is correct, will vet it and reply if otherwise.

John