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: 
qlikwiz123
Creator III
Creator III

Age in Set Analysis

How do I use Age function in Set Analysis?

 

Age([END DATE],[START DATE]) 

How do I add Set Analysis condition on this? Like calculate age for Concept=A

Labels (2)
1 Solution

Accepted Solutions
usamabinsadiq
Contributor III
Contributor III

Hi,

with age function you cannot use set analysis but you can use sum on top of it to filter data then apply age function like :

sum({$<Concept={'A'}>} Age([END DATE],[START DATE]))

so when you use it with dimension it will work accordingly.

hope this helps.

 

Regards,  

if my replay helped you then please press like button and do not forget to press the "Accept as Solution" button.

View solution in original post

2 Replies
usamabinsadiq
Contributor III
Contributor III

Hi,

with age function you cannot use set analysis but you can use sum on top of it to filter data then apply age function like :

sum({$<Concept={'A'}>} Age([END DATE],[START DATE]))

so when you use it with dimension it will work accordingly.

hope this helps.

 

Regards,  

if my replay helped you then please press like button and do not forget to press the "Accept as Solution" button.
qlikwiz123
Creator III
Creator III
Author

Thanks @usamabinsadiq