Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Aggr Count by Dimension Question

Hi All,

How do I count the half_hr_bucket by date? I tried this expression but it does not return anything. Please help!

=Aggr(count(half_hr_bucket),date)

  

datehalf_hr_bucket
1/2/201509:00 - 09:30
1/2/201509:30 - 10:00
1/2/201510:00 - 10:30
1/2/201510:30 - 11:00
1/2/201511:00 - 11:30
1/5/201513:30 - 14:00
1/5/201514:00 - 14:30
1/5/201514:30 - 15:00
1/5/201515:00 - 15:30
1/5/201515:30 - 16:00
1/5/201516:00 - 16:30
1/5/201516:30 - 17:00
1/5/201517:00 - 17:30
1/5/201517:30 - 18:00
1/6/201509:00 - 09:30
1/6/201509:30 - 10:00
1/6/201510:00 - 10:30
1/6/201510:30 - 11:00
1/6/201511:00 - 11:30
1/6/201511:30 - 12:00
1/7/201514:00 - 14:30
1/7/201514:30 - 15:00
1/7/201515:00 - 15:30
1/7/201515:30 - 16:00
1/7/201516:00 - 16:30
1/7/201516:30 - 17:00
1/7/201517:00 - 17:30
1/7/201517:30 - 18:00

Thank you for your inputs.

4 Replies
ramoncova06
Valued Contributor III

Re: Aggr Count by Dimension Question

is this in a straight table ?

you can use

=count(total <date> half_hr_bucket)

krishna_2644
Valued Contributor III

Re: Aggr Count by Dimension Question

see attached:

Capture1.PNG

Not applicable

Re: Aggr Count by Dimension Question

@ Krishna: I used your expression and made small change and it worked for me now. Thank you!

@Ramon: Thank you for your reply.

krishna_2644
Valued Contributor III

Re: Aggr Count by Dimension Question

Awesome. Please close the thread as 'Answered'

Community Browser