help reducing script

[#1]

Hi all

I have been struggling with a date issue, creating the right finance date. I have now got a solution that works and seems to give me the right FinanceDate, in a lot of different situations.

But I think the script could be done in a "easier" way, I just can't get it right

so do any one of all you great Qlikers have another solution

Attached example qvw and data file

Regards

NJ

[MK_QSL]

Can you provide FinanceDate Table excel file?

[#3]

Hi Manish

Other Finance dates is comming from another sales table, with all dates for month and year, where this is concatenated to.

So it would just be all dates, and shouldn't matter here

regards

NJ