Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi
Its looks fine.
can u send the error message
@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
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.
Hi
Its looks fine.
can u send the error message
@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
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 😊
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.