topic Re: Calculation based on previous number in QlikView

Calculation based on previous number

sumeet-vaidya — Wed, 05 Sep 2018 12:06:26 GMT

Hi,

Kindly find below table and required otuput. This needs to be achieved in frontend. Please assist.

Channel	Value %	Calculation !	Required Output
A	-15	If(Negative then 0)	0
B	5	-15+5 = -10 (Again negative then 0)	0
C	13	-10 + 13 = 3	3
D	32		32
E	65		65
Total	100		100

stalwar1‌

Regards

Sumeet

Re: Calculation based on previous number

giovanneb — Wed, 05 Sep 2018 13:08:33 GMT

Hi, try this,

tmp:

LOAD * Inline [

Channel, Value

A, -15

B, 5

C, 13

D, 32

E, 65

];

tmp1:

LOAD

Channel,

Value,

if(RowNo() = 1, Value,

Peek(x) + Value) as x

Resident tmp;

DROP Table tmp;

tmp2:

LOAD

if(y < 0, 0, y) as z;

LOAD

if(Peek(x) > 0, Value, x) as y

Resident tmp1;

DROP Table tmp1;

DROP Fields x,y;

Reguards

Re: Calculation based on previous number

manoranjan_d — Wed, 05 Sep 2018 14:19:06 GMT

try this

create one straight table and

add the dimension as channel

expression 1 as sum(value)

expression 2 as =if(RangeSum(Above(Value,0,2))<0,'0',RangeSum(Above(Value,0,2)))

Re: Calculation based on previous number

sunny_talwar — Thu, 06 Sep 2018 13:03:23 GMT

May be try this

=If(Alt(Above(RangeSum(Above(Sum(Value), 0, RowNo()))), -1) < 0, RangeMax(RangeSum(Above(Sum(Value), 0, RowNo())), 0), Sum(Value))

Re: Calculation based on previous number

manoranjan_d — Thu, 06 Sep 2018 13:52:27 GMT

great

Re: Calculation based on previous number

sumeet-vaidya — Thu, 20 Sep 2018 07:09:20 GMT

Great Sunny..!!! Thanks a ton

Regards

Sumeet