This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I essentially have 4 date fields,
I am trying to create a flag which essentially sets the flag as '1' where datestart1 and dateend1 is within datestart2 and dateend2.
This would occur as a Flag of '1' as datestart1 and dateend1 is within datestart2 and dateend2. However,
This would occur as a Flag of '0', as the datestart1 and dateend1 is not within datestart2 and dateend2.
Is there a function within Qlik that allows me to do this? or what would be the best way to do this?
You can use a simple if claue to do this.
iF(datestart1>= datestart2 and datestart1<= dateend2 and dateend1>= datestart2 and dateend1<= dateend2 ,1,0) as Flag