topic Re: Help in logic development in App Development

Help in logic development

Crimson_BI — Thu, 21 Dec 2023 08:59:10 GMT

Hello Team,

Required some help in logic development in the backend script, my requirement is to compare the current record with respect to above record, Please find example below

Column A, B are input for me required Column C as output

Thanks in advance

Re: Help in logic development

vincent_ardiet_ — Thu, 21 Dec 2023 09:17:16 GMT

Look at the previous() function, this should help https://help.qlik.com/en-US/sense/August2023/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecordFunctions/Previous.htm

Re: Help in logic development

Crimson_BI — Fri, 22 Dec 2023 05:29:50 GMT

Hello @vincent_ardiet_

Have tried this but it is not working because the output is coming below

Thanks in advance

Re: Help in logic development

vincent_ardiet_ — Fri, 22 Dec 2023 07:39:53 GMT

you can change the sort order of your table

Re: Help in logic development

Fabiano_Martino_Intelco — Fri, 22 Dec 2023 07:44:59 GMT

Hi @Crimson_BI ,

I got the expected result with this code:

Base_Table:

LOAD * INLINE [

A, B

ABC, ABC-1

ABC, ABC-2_1

ABC, ABC-2_2

ABC, ABC-3

];

Result_Table:

Load

A as A_Result,

B as B_Result,

Peek('B', RowNo(), 'Base_Table') as [Modified B]

Resident Base_Table;

@vincent_ardiet_ is also right, if you can sort the table you can use the previous() function.

Regards