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
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
akuttler
Creator
Creator

Current Aging Total Variable

I need help to create a variable for the most current total AR IB Balance. I have the Expression below:

sum({<[Date of AR Run] = {'Max([Date of AR Run])'}>} [Total IB])

But the result is null.

Thanks.

1 Solution

Accepted Solutions
sunny_talwar

Try this

Sum({<[Date of AR Run] = {"$(=Date(Max([Date of AR Run]), 'M/D/YYYY'))"}>} [Total IB])

View solution in original post

7 Replies
sunny_talwar

Try this

Sum({<[Date of AR Run] = {"$(=Max([Date of AR Run]))"}>} [Total IB])

jolivares
Specialist
Specialist

Try to put :

sum({<[Date of AR Run] = {'Date(Max([Date of AR Run]))'}>} [Total IB])


With the same format MM/DD/YYYY for both dates


akuttler
Creator
Creator
Author

I tried both, and the the result is Zero now...

sunny_talwar

What is your date field format?

akuttler
Creator
Creator
Author

Capture.PNG

sunny_talwar

Try this

Sum({<[Date of AR Run] = {"$(=Date(Max([Date of AR Run]), 'M/D/YYYY'))"}>} [Total IB])

akuttler
Creator
Creator
Author

Thanks it worked!