# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor

## 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.

Tags (1)
1 Solution

Accepted Solutions
MVP

## Re: Current Aging Total Variable

Try this

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

7 Replies
MVP

## Re: Current Aging Total Variable

Try this

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

Valued Contributor

## Re: Current Aging Total Variable

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

Contributor

## Re: Current Aging Total Variable

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

MVP

## Re: Current Aging Total Variable

What is your date field format?

Contributor

MVP

## Re: Current Aging Total Variable

Try this

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

Contributor

## Re: Current Aging Total Variable

Thanks it worked!