https://community.qlik.com/t5/QlikView/Need-help-with-a-variant/m-p/1942260#M1222878 <P>Replace [Negative Amount] with Amount*-1 or use preceeding load</P> <P>Regards,</P> <P>Aditya</P> Fri, 10 Jun 2022 14:39:00 GMT Aditya_Chitale 2022-06-10T14:39:00Z https://community.qlik.com/t5/QlikView/Need-help-with-a-variant/m-p/1942256#M1222877 <P>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.</P> <P>Load<BR />Period,<BR />[Company Code] as [CC],<BR />Amount,<BR />Amount * -1 as [Negative Amount],<BR />[Negative Amount] /1000 as [Neg Amount in miles]</P> <P>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.</P> <P>Pleasee help,</P> Fri, 10 Jun 2022 14:33:49 GMT https://community.qlik.com/t5/QlikView/Need-help-with-a-variant/m-p/1942256#M1222877 zeref 2022-06-10T14:33:49Z https://community.qlik.com/t5/QlikView/Need-help-with-a-variant/m-p/1942260#M1222878 <P>Replace [Negative Amount] with Amount*-1 or use preceeding load</P> <P>Regards,</P> <P>Aditya</P> Fri, 10 Jun 2022 14:39:00 GMT https://community.qlik.com/t5/QlikView/Need-help-with-a-variant/m-p/1942260#M1222878 Aditya_Chitale 2022-06-10T14:39:00Z