Solved: Re: Age function - Qlik Community

earlcool · ‎2022-05-23

I have a database with birth_date.

I use

Age(Today(), birth_date) as Age

I used later

=Count(Age >=18)

but it does not seem to work.

HugoRomeira_PT · ‎2022-05-23

Hello,

For the count, try the following function:

=count({<Age={">=18"}>} Age)

If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.

HugoRomeira_PT · ‎2022-05-23

Hello,

For the count, try the following function:

=count({<Age={">=18"}>} Age)

If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.

earlcool · ‎2022-05-24

thanks for the answer, however the personID makes a lot of visits to the store and they get counted on every visit.

I did create the database. I want to find the distinct or unique number without double counting.

thanks again.

Age function