Need help with a variant (?

[MiguelHathaway]

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. 

YourTexasBenefits

Pleasee help,

[vchuprina]

Hi,

Try this:

Load *,

[Negative Amount] /1000 as [Neg Amount in miles];

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

From your excel;

Regards, 

Vitalii

[smith11484]

Try something like this, it's called a preceding load. You can transform data then load it again, and reference newly created columns, as it's all in memory. That's what the 2nd load statement is doing

Load [Negative Amount] / 1000 as [Neg amount in miles], *; Load Period, [Company code] as CC, Amount, Amount * -1 as [Negative Amount]

official website

[SadlerS]

Cough, runny nose, fatigue, sore throat, headache, muscle pain, fever and sneezing - are the 8 Omicron symptoms that are flu-like.

MyMileStoneCard Login 

[NitinK7]

Hi,

Try this:

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

(Amount * -1)/1000 as [Neg Amount in miles];

From your excel;