Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
True() is always -1 in qlik. I don't see an instance where it returns 1 instead. Have you noticed such a case ?
Its been same, Just curious to understand why it is -1.
Read this:On Boolean Fields and Functions
All Boolean functions and operations, e.g. IsNull(), True() and comparisons such as Date=Today() return 0 for FALSE and -1 for TRUE. Why minus one? Because it is equivalent to setting all the bits in the byte to 1, which is how TRUE is represented in most software systems (as opposed to FALSE, where all bits are set to 0).