topic Reduction Column logic in QlikView

Reduction Column logic

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

Hi All,

Stuck into develop below logic please help.

Column D is a formula for reference to calculate column C Please help

MONTHS	Amount	Reduction	Formula
OPENING	542.8	0.0	B2-C2
3	541.2	-2.6	B2-C3
4	538.6	0.0	B2-C4
5	537.2	1.4	B2-C5
6	533.1	5.5	B2-C6
7	528.0	10.6	B2-C7
8	528.0	10.6	B2-C8
9	528.0	10.6	B2-C9

Re: Reduction Column logic

Saravanan_Desingh — Sun, 19 Jul 2020 18:30:26 GMT

Do you mean to say for example C2=B2-C2? I can't understand.

Re: Reduction Column logic

Harsh9971 — Mon, 20 Jul 2020 13:24:54 GMT

see below condition

if( month='opening',GNPA,0) - GNPA

I want to substract all GNPA Amount from 542.8

Re: Reduction Column logic

Kushal_Chawda — Mon, 20 Jul 2020 14:43:26 GMT

Do you get opening as it is in Month Data or it is calculated?

Re: Reduction Column logic

Harsh9971 — Mon, 20 Jul 2020 16:49:39 GMT

'Opening' is hard coded value in script for month column.

and other number are DAY(TODAY())

Re: Reduction Column logic

Brett_Bleess — Wed, 29 Jul 2020 13:17:58 GMT

Just adding a new comment to kick this one back out to see if someone else may be able to offer up anything, I am not sure I am the right resource to try to help on this one, sorry.

Regards,
Brett

Re: Reduction Column logic

Kushal_Chawda — Wed, 29 Jul 2020 14:37:15 GMT

@Harsh9971 your column D formula completely differs from formula in C. It's confusing. Can you please update?