Picking result of the expression in the same Field

[rvc_121985]

Namaste,

Looking for a expression or the way where expression picks the result of the same expression the the same field. Most of us might have done this in Excel.

For example: In excel Normally we use as below (Say formulae in Column "C"):

Cell C2 = If(A2="Apple1", "Apple", if(A2="APP", C1 , "A2"))

in the above formulae C1 is the first row and the same will be copied to all the cells of column "C", Every next cell of "C" will cross check the result from above cell.

Is this something possible Directly or indirectly in the Qlik Sense?

[brunobertels]

Hi 

Try this 

A : DIM = the Name of your column : 

C : 

If(A='Apple1', 'Apple', if(A='APP', previous(C) , A)) 

[MarcoWedel]

Do you want to create this logic in the script or in a chart?

[rvc_121985]

Hi MarcoWedel,

Yes, in the script.

Thanks,

[MarcoWedel]

LOAD If(A='Apple1', 'Apple', If(A='APP', Peek(C) , A)) as C
FROM YourSource;