topic Age calculation within set analysis, not able to do it in the load in App Development

Age calculation within set analysis, not able to do it in the load

LL-HvD — Thu, 17 Feb 2022 13:59:52 GMT

Hello community,

I am developing a Qlik Sense app wherein the user selects their own parameters from a date picker, and so I need to calculate their age based on the selected date. I have DOB as a field, and the selected date parameter is called DateBegin. Currently, to calculate the number of members at the selected date, I have:

Count({<StartDate={"<=$(DateBegin)"},CanxDate={">$(DateBegin)"},Relation={'Primary Member'},ClaimDate=>} distinct MemberNo)

I need within there to somehow add 'Age(DateBegin,DOB)>=65', but I can't work it out from any previously answered questions. Please help!

Re: Age calculation within set analysis, not able to do it in the load

stevejoyce — Thu, 17 Feb 2022 14:13:08 GMT

Count({<MemberNo = {"=Age(DateBegin,DOB)>=65"}, StartDate={"<=$(DateBegin)"},CanxDate={">$(DateBegin)"},Relation={'Primary Member'},ClaimDate=>} distinct MemberNo)

Re: Age calculation within set analysis, not able to do it in the load

LL-HvD — Thu, 17 Feb 2022 14:41:12 GMT

Thanks Steve. It's not giving me the number I'm expecting, but I don't think that's necessarily a problem for you to solve. I could only get '0' or '-' before, so it's moved me a long way in the right direction!