topic Re: above function in QlikView

above function

sagaraperera — Wed, 25 Nov 2020 16:16:04 GMT

Dear all

I want to get a figure below 100000 7 above 100000 i try it but not work my normal expression given below. please help me

Sum (GROSSTOT)

sagara

Re: above function

swuehl — Mon, 07 Mar 2016 11:25:22 GMT

Sorry, I didn't get what you are trying to achieve.

Could you post a screenshot or some sample lines of table records?

In which context do you want to do the calculations? Script? Chart?

Re: above function

sagaraperera — Mon, 07 Mar 2016 11:32:42 GMT

THANKS FOR YOUR REPLY

I TRY TO GET FIGURE SEPARATELY FIRST ONE BELOW 100000 & SECOND ONE ABOVE 100000

MY SCRIPT

LOAD BCOD,

CLA_CODE,

PRD_CODE,

POLICY_NO,

REF_NO,

MDATE,

YEAR,

MONTH,

NAME,

ME_CODE,

//TRN_DATE,

DATE(floor(TRN_DATE)) as TRN_DATE,

TRAN_YEAR,

TRAN_MONTH,

POL_PERIOD_FROM,

SCCOD,

CP,

RS,

TC,

GROSSTOT,

N_R_NOS1,

F_NOS2

Re: above function

swuehl — Mon, 07 Mar 2016 11:38:21 GMT

Maybe like

Result:

LOAD ....

GROSSTOT,

If( GROSSTOT>=10000 and previous(GROSSTOT)< 10000, previous(GROSSTOT) ) as FirstUnder10000,

If(GROSSTOT>=10000 and previous(GROSSTOT)< 10000, GROSSTOT) as FirstAbove10000,

If(Peek(FirstAbove10000) >0, GROSSTOT) as SecondAbove10000

....

RESIDENT YourTable

ORDER BY GROSSTOT asc;

DROP TABLE YourTable;