We generally want our flags to be positive 1 so we can use the flag in a multiplication expression like:
=sum(LineSalesAmount * CurYTDFlag)
In qlikview, True is represented by -1. If the flag is created in script using a function that returns true/false (like InYearToDate) we multiply the result by -1 to derive a positive flag. For example:
InyearTodate(mydate,today()) * -1 as CurYTDFlag
-Rob
