topic Why multiply by(-1) in Flags? in QlikView

Why multiply by(-1) in Flags?

Wed, 03 Sep 2014 19:54:38 GMT

Please let me know

Re: Why multiply by(-1) in Flags?

mseeck75 — Wed, 03 Sep 2014 20:20:34 GMT

Hello Kay,

what do you mean with flags? Can you please post some more information about your problem.

Matthias

Re: Why multiply by(-1) in Flags?

MarcoWedel — Wed, 03 Sep 2014 20:33:16 GMT

please specify your question.

One possible answer:

logical value true is represented by -1

regards

Marco

Re: Why multiply by(-1) in Flags?

rwunderlich — Wed, 03 Sep 2014 21:26:49 GMT

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