Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Display ;ist of people celebrating birthday this month

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

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

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

View solution in original post

4 Replies
MK_QSL
MVP
MVP

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)

Not applicable
Author

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
MVP
MVP

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

Not applicable
Author

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

Cheers.