Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

akuttler
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

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

Re: Current Aging Total Variable

Try this

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

jolivares
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


akuttler
Contributor

Re: Current Aging Total Variable

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

Re: Current Aging Total Variable

What is your date field format?

akuttler
Contributor

Re: Current Aging Total Variable

Capture.PNG

Re: Current Aging Total Variable

Try this

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

akuttler
Contributor

Re: Current Aging Total Variable

Thanks it worked!

Community Browser