Solved: calculated field in load calculation - Qlik Community - 1361364

Skip to main content

Qlik.com | Qlik Help | Resources

Ask a Question

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

x, x, x, x

];

NewTable:

load *,

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

Resident Exercises;

1 Solution

Accepted Solutions

Hi,

Try this.

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

2 Replies

Hi,

Try this.

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Author

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