Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jbakerstull
Contributor

Average Age by gender

I'm trying to figure out who to write a formula for average age by gender type.

I've tried: but the result is '-'

=Avg( {$<[SVPPROFGENDER_entry] ='Female'>} Aggr(Avg(floor(Age('4/1/2018',[SVPPROFDOB_entry]))),[Client Id],[SVPPROFDOB_entry]))

1 Solution

Accepted Solutions

Re: Average Age by gender

May be this... but is this only needed for Female?

=Avg({$<[SVPPROFGENDER_entry] = {'Female'}>} Aggr(Avg(Floor(Age('4/1/2018', [SVPPROFDOB_entry]))), [Client Id], [SVPPROFDOB_entry]))

2 Replies

Re: Average Age by gender

May be this... but is this only needed for Female?

=Avg({$<[SVPPROFGENDER_entry] = {'Female'}>} Aggr(Avg(Floor(Age('4/1/2018', [SVPPROFDOB_entry]))), [Client Id], [SVPPROFDOB_entry]))

jbakerstull
Contributor

Re: Average Age by gender

Thank you very much. Hope your day goes well.

Community Browser