Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Count Days Based on Conditions

HI

Please find attached the data .

And the output based on data is as given below.

     

StaffNameAvg Distinct Message per DayNumber of days with Distinct Message  > 500Max Distinct Message procesed in a dayMin Distinct Message procesed in a day
ABC45547151
2 Replies

Re: Count Days Based on Conditions

Hi Senthil,

Have you tried something?

you can achieve this using the aggregation. 

2.JPG

PFA for reference.

Re: Count Days Based on Conditions

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))

Capture.PNG

Best,

Sunny

Community Browser