Re: Reduction Column logic - Qlik Community

Harsh9971 · ‎2020-07-19

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

Saravanan_Desingh · ‎2020-07-19

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

Harsh9971 · ‎2020-07-20

see below condition

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

I want to substract all GNPA Amount from 542.8

Kushal_Chawda · ‎2020-07-20

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

Harsh9971 · ‎2020-07-20

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

and other number are DAY(TODAY())

Brett_Bleess · ‎2020-07-29

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

Kushal_Chawda · ‎2020-07-29

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