Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Taavu82
Contributor II
Contributor II

Age Calculation only display if greater than

Hello! 

New here, and looking for some advice on how to calculate the age of a member, and then only display the member in the table if their age is greater than 26. 

I am already using the following expression to calculate age, but I'm not able to determine how to only display if greater than 26. 

=Age(Now(),MEMBER_BIRTH_DATE)

Any help would be appreciated, thanks! 

Labels (2)
1 Solution

Accepted Solutions
HugoRomeira_PT
Creator
Creator

Hello,

A simple if should do the trick:

=if(Age(Now(),MEMBER_BIRTH_DATE)>26, Age(Now(),MEMBER_BIRTH_DATE), null())

 

Hope it helps.

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.

View solution in original post

2 Replies
HugoRomeira_PT
Creator
Creator

Hello,

A simple if should do the trick:

=if(Age(Now(),MEMBER_BIRTH_DATE)>26, Age(Now(),MEMBER_BIRTH_DATE), null())

 

Hope it helps.

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.
Taavu82
Contributor II
Contributor II
Author

That did the trick, thank you so much!