Link with Master Calendar

[bvssudhakar]

Hi Experts,

Here I am attaching my qvd and qvw files, Can you guys please help me out for the below mentioned challenge:

I have a multiple date columns in my file. Now i want to create master hierarchy calendar for and link with all the dates. because i want to show only one list box in my report i.e. hierarchy calendar list box. For that i wrote some script but i was strucked somewhere

Output scenario:

I want to create a text object for joiners

for that expression is like this: Count(candidateID) but these candidate id's count are based on plcdate column.

If i select April Month and 2018 year from hierarchy calendar list box output should be 15 for this text object.

Please Help me out from this guys.

mbaeyens‌manoj217‌rwunderlich‌franky_h79‌priyalvp24‌swuehl‌petter-s‌trdandamudi‌stalwar1‌loveisfail‌

Thank you in advance

[priyalvp24]

Send ur email id

[bvssudhakar]

Hi

This is my mail id : bvss6969@gmail.com

[bvssudhakar]

Hi priyalvp24‌

did you find any solution??

[priyalvp24]

Check your email & try that solution,

Let me know whether its working or not

[bhaskar_sm]

Hi,

Please find attached the QVF for your reference.

I have created only on command date filed you can also create calendar hierarchy based on the date filed

please let me know in case any query.

if you found this helpful ! ! ! mark help or correct.

Regards,

Bhasker Kumar

[priyalvp24 · Accepted solution]

Use this

=Count({<Recruiter={'Irfan Memon','Rajiv Ranjan','Aditi Saxena','Sneha Singh'},plcdate=-{''}>}Distinct CandidateID)

[bvssudhakar]

Hi Priyal,

Thank you very much for giving me the solution. It is working for me

[bvssudhakar]

Hi Bhasker,

Thank you very much for the help and whatever you give the solution that is also working fine.

[bvssudhakar]

Hi Rajiv,

Thank you for the help, Whatever you shared with that is also working properly for linking with master calendar