Scripting

[powerqlik]

Hello fellow Qlikview users.  Can someone please help modify my script to be able to calculate remaining obligation expense?  Thanks in advance!

The script below calculates the total lease obligation.  I want to be able to modify this script so that it would calculate the total remaining lease obligation as of this month or as of today.

(sum({$<LocalLeaseTypeExpenses = {Lease}, Expense = {"*"}>} Amount))

[powerqlik]

I really wish I could but since the data and file belongs to my employer, I wouldn't be able to attach it even if I scrambled the data.  I have been struggling attaching screenshots because of the data blocker we have on our side.  In any case, I greatly appreciate all of your efforts.  Maybe I can create a sample file when I am home and try to attach that?

[sunny_talwar]

That would be the only way I can really help because I am not sure what might be the issue without taking a look at it

[powerqlik]

I completely understand and you have invested more time on this request than I could of asked for.  I will see if there is someway I can get you a sample file.