topic Re: calculated field in load calculation in QlikView

calculated field in load calculation

twills12 — Wed, 25 Nov 2020 16:16:04 GMT

Is it possible to create/use a calculated field on the load where you reference itself?

Exercises:

Load * Inline [

ID, Exercise, Date, Result

x, x, x, x

];

NewTable:

load *,

if(previous(Status) = 'Tier1', 'Tier2', 'Tier1') as Status

Resident Exercises;

kaushiknsolanki — Mon, 24 Jul 2017 17:46:58 GMT

Hi,

Try this.

if(Peek(Status) = 'Tier1', 'Tier2', 'Tier1') as Status

Regards,

Kaushik Solanki

twills12 — Mon, 24 Jul 2017 17:49:49 GMT

That did it! Peek instead of Previous... now I know. Thanks!!!!