topic Re: Alternative of Above() Function in Backend Script. in QlikView

Alternative of Above() Function in Backend Script.

Wed, 25 Nov 2020 16:16:04 GMT

Hi All

Is there any Alternative for Above() Function in backend Script.

I don't wan't to use Order By desc in Script.

because I need Previous() and Above() at the same time.

I have achieved Result with Previous but for Above() I haven't received the Result.

See this:

See the Attachment.

Regards

Eric

Re: Alternative of Above() Function in Backend Script.

tyagishaila — Tue, 22 Mar 2016 08:42:58 GMT

Your desired output needs Below() not Above().

PFA

Cheers,

Re: Alternative of Above() Function in Backend Script.

Chanty4u — Tue, 22 Mar 2016 08:46:18 GMT

i thnk below will work

chk this

Missing Manual - Above() and Below()

Re: Alternative of Above() Function in Backend Script.

jvishnuram — Tue, 22 Mar 2016 08:46:52 GMT

Hi Eric,

You should use below() function to achieve your result, PFA

Re: Alternative of Above() Function in Backend Script.

senpradip007 — Tue, 22 Mar 2016 08:48:06 GMT

You can use Peek() apart from Above().

Re: Alternative of Above() Function in Backend Script.

Digvijay_Singh — Tue, 22 Mar 2016 08:49:37 GMT

Try this script -

t1:

Load * inline [

Number, Name, Code_1

1,India,NOT SAME

2,India,SAME

3,Uk,NOT SAME

4,Uk,SAME

5,Uk,SAME

6,USA,NOT SAME

7,Russia,NOT SAME

8,France,NOT SAME ];

t2:

Load *,

alt(Peek('Code_1',Recno(),'t1'),Code_1) as Code_2

Resident t1;

drop table t1;

Re: Alternative of Above() Function in Backend Script.

sunny_talwar — Tue, 22 Mar 2016 08:49:56 GMT

Can be done without Aggr() function as well:

If(Below(TOTAL Name) = Name, 'Same', 'No Same')

Re: Alternative of Above() Function in Backend Script.

jagan — Tue, 22 Mar 2016 08:53:15 GMT

Hi,

Try Peek().

Regards,

Jagan.

Re: Alternative of Above() Function in Backend Script.

sunny_talwar — Tue, 22 Mar 2016 09:01:37 GMT

Yet another method could be using a similar to As-of Table concept:

Table:

LOAD *,

IF(Previous(Name)=Name,'SAME','NOT SAME') AS Code_1 INLINE [

NUMBER, Name

1, INDIA

2, INDIA

3, UK

4, UK

5, UK

6, USA

7, RUSSIA

8, FRANCE

];

Link:

LOAD NUMBER as LINK_NUM,

NUMBER,

'C' as Flag

Resident Table;

Concatenate (Link)

LOAD NUMBER as LINK_NUM,

NUMBER + 1 as NUMBER,

'L' as Flag

Resident Table;

Data Model:

Straight table

Dimension: LINK_NUM

Expression:

1) =Only({<Flag = {'C'}>} Name)

2) =If(Only({<Flag = {'C'}>} Name) = Only({<Flag = {'L'}>} Name), 'SAME', 'NOT SAME')

Re: Alternative of Above() Function in Backend Script.

Tue, 22 Mar 2016 09:13:08 GMT

Hi All

I appreciate each and everyone's effort but i want the logic in Back end at Script level not at front end chart level.

Also, I need the Code_1 and Code_2 in one Load. I don't have to use concatenate.

Re: Alternative of Above() Function in Backend Script.

Digvijay_Singh — Tue, 22 Mar 2016 11:58:35 GMT

Did you try this?

Re: Alternative of Above() Function in Backend Script.

swuehl — Tue, 22 Mar 2016 12:04:24 GMT

I believe you can't access the next input record from the current input record (in contrary to the previous record using previous() function), so QlikView won't allow to see the future, if that's what you are after.

If you have loaded the complete table, you can access the records in subsequent loads in different ways, but as I read your request, that's not what you want.

Re: Alternative of Above() Function in Backend Script.

sudhir0538 — Mon, 19 Mar 2018 03:13:10 GMT

Hello Sunny / Stefan !

Can u help in my case too !!

Compare with Old Data