topic Re: Picking result of the expression in the same Field in App Development

Picking result of the expression in the same Field

RC_121985 — Sat, 16 Nov 2024 16:52:23 GMT

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?

Re: Picking result of the expression in the same Field

brunobertels — Fri, 31 Dec 2021 08:48:58 GMT

Try this

A : DIM = the Name of your column :

C :

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

Re: Picking result of the expression in the same Field

MarcoWedel — Sun, 02 Jan 2022 13:01:29 GMT

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

Re: Picking result of the expression in the same Field

RC_121985 — Mon, 03 Jan 2022 08:00:24 GMT

Hi MarcoWedel,

Yes, in the script.

Thanks,

Re: Picking result of the expression in the same Field

MarcoWedel — Tue, 04 Jan 2022 22:14:31 GMT

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