Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
yes , doing it now. many thanks vinime12 ! thanks for saving me!