How to create a flag based on blocking date

[jim_chan]

Hi all the master!

I have a issue here. i got a data from user, generated by system. 

My request is - how to create a Block Indicator Flag - X, based on 2 block dates column - a from & to date, like the screenshot below.

so actually, this camp ID 1234, for year 2020, it closes from 1/5/2020 - 31/12/2020. but something wrong with the system, the system generated indicator(BLOCKED_IND), added in late, so the X only start on 13/09/2020.

So for now, i need to create a new field(Flag), that this new indicator flag, will flag from date 1/5/2020 - 31/12/2020. so i can use this new flag , instead from the system.

I have prepared an sample excel as well - 2 sheets, ISSUE and EXPECTED.

I will be working in qlik sense(QVF) file, i dont have QLIKVIEW qvw license. This has to be done in loading script.

ISSUE

EXPECTED(samples screenshot) , please view the excel.

Please help !

Rgds

Jim

[jim_chan]

yes , doing it now. many thanks vinime12 ! thanks for saving me!