topic Re: Count Days Based on Conditions in QlikView

Count Days Based on Conditions

Thu, 16 Jul 2015 12:56:53 GMT

Please find attached the data .

And the output based on data is as given below.

StaffName	Avg Distinct Message per Day	Number of days with Distinct Message > 500	Max Distinct Message procesed in a day	Min Distinct Message procesed in a day
ABC	455	4	715	1

settu_periasamy — Thu, 16 Jul 2015 13:18:07 GMT

Hi Senthil,

Have you tried something?

you can achieve this using the aggregation.

PFA for reference.

sunny_talwar — Thu, 16 Jul 2015 13:22:59 GMT

Here you go: PFA

Exp1: =Avg(Aggr(Count(Message), Date))

Exp2: =Count(If(Aggr(Count(Message), Date)>500, Date))

Exp3: =Max(Aggr(Count(Message), Date))

Exp4: =Min(Aggr(Count(Message), Date))

Best,

Sunny