Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Count({<MemberNo = {"=Age(DateBegin,DOB)>=65"}, StartDate={"<=$(DateBegin)"},CanxDate={">$(DateBegin)"},Relation={'Primary Member'},ClaimDate=>} distinct MemberNo)
Count({<MemberNo = {"=Age(DateBegin,DOB)>=65"}, StartDate={"<=$(DateBegin)"},CanxDate={">$(DateBegin)"},Relation={'Primary Member'},ClaimDate=>} distinct MemberNo)
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!