Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please let me know
Hello Kay,
what do you mean with flags? Can you please post some more information about your problem.
BR
Matthias
please specify your question.
One possible answer:
logical value true is represented by -1
regards
Marco
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