Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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

Re: Display ;ist of people celebrating birthday this month

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

4 Replies

Re: Display ;ist of people celebrating birthday this month

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

Re: Display ;ist of people celebrating birthday this month

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?

Re: Display ;ist of people celebrating birthday this month

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

Not applicable

Re: Display ;ist of people celebrating birthday this month

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

Cheers.