topic Re: Age in Set Analysis in QlikView

Age in Set Analysis

qlikwiz123 — Sat, 16 Nov 2024 00:52:42 GMT

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

usamabinsadiq — Wed, 08 Apr 2020 16:02:56 GMT

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,

qlikwiz123 — Wed, 08 Apr 2020 16:15:47 GMT