How to use Subtraction or Less than in Qlikview script

[NabeelAbid]

Please assist me in typing the correct script of Qlikview. Screenshot attached. I want to subtract one column from another column of the QVD FILE.

I have to submit an analysis report by Monday in the office.

Thanks in Advance.

[MayilVahanan · Accepted solution]

Hi

Its looks fine.
can u send the error message

[sidhiq91 · Accepted solution]

@NabeelAbid I don't see any issues with the expression too. But instead of 2 if Statements, you can just have a single if statement something like below:

if((ClosingBalance-CurrentAmount)<3000,'Less than 3k','Above 3k') as OSD_Slab_Aug2021

[NabeelAbid]

Thanks alot!!! Really appreciated.

Actually I was making mistakes in other portions of script thats why was not working. This time I reloaded new QVD file and then make IF statements.

Once again thank you very much for your time and assistance 😊

[NabeelAbid · Accepted solution]

I made mistakes in other portions of script. Now I resolved it. Your suggestion of single IF statement is also working good. However, I found some errors when exporting excel file. i.e showing 'Above 3K' status in front of below 3K values. 

I am attaching excel file for your review.

Thanks.