Display ;ist of people celebrating birthday this month

[#1]

Hello,

I would like a list of all the people celebrating their birthdays this month.

I have a table containing the fullname and DOB. the result should be a table with fullName and DOB as (DD/MM)

The awnser should have something to do with set analysis but i don't seem to get the syntax right since QlikSense keeps telling me there is an error in the expression.

Please help

[MK_QSL]

Considering that your Date format is DD/MM/YYYY.

Create a Straight Table

Dimension

NAME

EXpression

IF(Date#(LEFT(DOB,5)&'/'&Year(Today()),'DD/MM/YYYY') >= MonthStart(Today()) and Date#(LEFT(DOB,5)&'/'&Year(Today()),'DD/MM/YYYY') <= MonthEnd(Today()),DOB)

[#3]

Hi Manish,

Thank you for your answer. Unfortunately this doesn't give me the  desired result.

I wish to only display those employees who celebrate their birthday this month. This expression

Sum({1< [MOB] = {feb}>} [DOB])

does give me the desired result. I created a field MOB (Month of Birth) in the script. But this is not dynamic.

The expression

Sum({1< [MOB] = {Month(Today())}>} [DOB])

doesn't seem to work. What am i doing wrong?

[MK_QSL · Accepted solution]

MOB = {'$(=Month(Today()))'}

[#5]

That's it! I didn't fully understand why functions need to be passed as being a variable. But it makes sense now.

Cheers.