Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Harsh9971
Contributor
Contributor

Reduction Column logic

Hi All,

Stuck into develop below logic please help.

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

MONTHSAmountReductionFormula
OPENING542.80.0B2-C2
3541.2-2.6B2-C3
4538.60.0B2-C4
5537.21.4B2-C5
6533.15.5B2-C6
7528.010.6B2-C7
8528.010.6B2-C8
9528.010.6B2-C9
6 Replies
Saravanan_Desingh

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

Harsh9971
Contributor
Contributor
Author

see below condition

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

I want to substract all GNPA Amount from 542.8 

Kushal_Chawda

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

Harsh9971
Contributor
Contributor
Author

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

and other number are DAY(TODAY())  

Brett_Bleess
Former Employee
Former Employee

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

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