Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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,
Hello @ayumi37 ,
@PrashantSangle provided a very good comment and you kind find more information on the preceding load here:
Cheers,
Albert
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,
Hello @ayumi37 ,
@PrashantSangle provided a very good comment and you kind find more information on the preceding load here:
Cheers,
Albert