The following SET expression is returning blank result , someone point out what could be the error

[vinayk1]

Hello Qlik community,

for the following set expression output is blank, please help in finding whats wrong with it.

MAKEDATE((IF(Match(GetFieldSelections(Value_Month),'Jan','Feb','Mar'),MAX({1}Value_Year)-2,MAX({1}Value_Year)-3)),
MONTH(MAX(Month)),DAY(MONTHEND(MAX(Month))))

ThankYou,

[PrashantSangle]

Expression is fine. Can share some screen shot of your data & output.

[marcus_sommer]

Just check each single part separately if they return the expected valid values and if you could put them together again - step by step.

[vinayk1]

Hi I did this exercise , all the elements in the expression work fine independently.

But when MAKEDATE is added it returns blanks

[marcus_sommer]

Where do you use this makedate()? All results are blank or only certain ones?

[vinayk1]

I have used it as variable to get a date range for YTD and MTD . 

This is what is am seeing.

[marcus_sommer]

From what is to see it looked ok. but it's not the entire statement. Just check again for any syntax issues, for example in regard to the right number of brackets and all fields are spelled properly. Further make sure that no comments are added within this and included variables. Also I would wrap the variable-call with $(...).