Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
NabeelAbid
Contributor II
Contributor II

How to use Subtraction or Less than in Qlikview script

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.

Labels (1)
3 Solutions

Accepted Solutions
MayilVahanan

Hi

MayilVahanan_0-1659251804622.png

 

Its looks fine.
can u send the error message

Thanks & Regards,
Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

sidhiq91
Specialist
Specialist

@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

 

View solution in original post

NabeelAbid
Contributor II
Contributor II
Author

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.

View solution in original post

4 Replies
MayilVahanan

Hi

MayilVahanan_0-1659251804622.png

 

Its looks fine.
can u send the error message

Thanks & Regards,
Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
sidhiq91
Specialist
Specialist

@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
Contributor II
Contributor II
Author

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
Contributor II
Contributor II
Author

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.