Hi, i'm New at Qlikview, and i'm trying to simplify my code but i can't do it.For example this is my code when I load information from an excel source.
Load Period, [Company Code] as [CC], Amount, Amount * -1 as [Negative Amount], [Negative Amount] /1000 as [Neg Amount in miles]
The code write with Bold, doesn't work, probably because "[Negative Amount]" it's not recognized from the source of the excel. But I need it to work, cause i'm on more complex formulas, and I need them to look easy to understand.
