Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Age function

Hi,

Can you let me know the syntax for below requirement :

Only those customer should display whose age is <20

having count of unique Product item which is greater than 1 have to be displayed

Regards,

1 Reply
olivierrobin
Specialist III
Specialist III

hello

where do you want to do so ?

in load ? in graph ?

how to you determine the age ?

you can use age() function which computes the difference in years between 2 dates

count can be achieved via a load group by for the script or with a set analysis in display