Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
jim_chan
Specialist
Specialist

How to create a flag based on blocking date

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

jim_chan_0-1652326789767.png

 

EXPECTED(samples screenshot) , please view the excel.

jim_chan_1-1652327554914.png

 

Please help !

 

Rgds

 

Jim

 

Labels (5)
10 Replies
jim_chan
Specialist
Specialist
Author

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