Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

an Aggr question

Hello,

I am stucked in a aggr task, so i really appreciate any help.

I have a table like this:  Dimension1, Dimension2, ..., DimensionN, Day     (Day is a Date field and can be empty), and I am trying to measure the eficiency of the activity, in terms of how many registrations per day you can do the same day. The aim is a table/chart like this, which would mean, for instance, that there are 198 days in which you were able to do 3 registrations in the same day.

Actions per day     Number of days

1                         87

2                         115

3                         198

4                         53

etc                        ...

Thanks.

Marc.

Tags (1)
7 Replies
Highlighted
MVP
MVP

Re: an Aggr question

Could you post a sample qvw?

Highlighted
Champion III
Champion III

Re: an Aggr question

Marc,

See my answers here: http://community.qlik.com/message/478904#478904

Regards,

Michael

Highlighted
Not applicable

Re: an Aggr question

Posted.

Highlighted
MVP
MVP

Re: an Aggr question

Qvw is empty(front-end). Reload; save; reupload.

Highlighted
Not applicable

Re: an Aggr question

Thanks Michael, I did it!

Highlighted
Creator III
Creator III

Re: an Aggr question

Hello, Marc

Using your data, I would use this calculated dimension:

=Aggr(Sum(ContadorVisita), FechaVisita)

And this expression:

Count({$<ContadorVisita = {">0"}>} Distinct FechaVisita)

I've attached an example QVW.

Bruno.

Highlighted
Not applicable

Re: an Aggr question

Great. Thanks