topic Re: Need help with a variant (? in QlikView

Need help with a variant (?

ayumi37 — Mon, 26 Jan 2026 18:19:17 GMT

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.

Pleasee help,

Re: Need help with a variant (?

PrashantSangle — Sat, 03 Sep 2022 14:04:48 GMT

Hello,

You can not use newly created field in same load. Either you have to use full field logic again or use preceding load.

For example

1: using same logic for new field again

Load
Period,
[Company Code] as [CC],
Amount,
Amount * -1 as [Negative Amount],
(-1* Amount) /1000 as [Neg Amount in miles]

or using preceding load

Load *, [Negative Amount] /1000 as [Neg Amount in miles];

Load
Period,
[Company Code] as [CC],
Amount,
Amount * -1 as [Negative Amount] from table;

Regards,

Re: Need help with a variant (?

Albert_Candelario — Mon, 05 Sep 2022 18:55:14 GMT

Hello @ayumi37 ,

@PrashantSangle provided a very good comment and you kind find more information on the preceding load here:

Preceding LOAD ‒ QlikView

Cheers,

Albert