7 Replies Latest reply: Nov 13, 2017 8:57 AM by Daniel Rodríguez

# Set analysis not working - Ignore selections

Hello all

First of all,thank you for your time. I really appreciate it.

I have an issue with set analysis and I'm not able to solve it. The problem is the following:

As you can see in this thread ( Working with dates - Last date ), I want to display just the last date data. With some help I was able to do it. The problem is that I want to ignore any filter I have and it seems that it's not working just with year and month. The formula I'm using is:

sum({1<[date_variable] = {'\$(maxdate)'}>}[A])

where maxdate is: max(date([date_variable]))

I don't see where is the problem as I'm using 1 to ignore all the selections...Is there anyone who can help me?

Thanks so much

• ###### Re: Set analysis not working - Ignore selections

Hi,

First take a text object and check that '\$(maxdate)' value is coming properly or not.

• ###### Re: Set analysis not working - Ignore selections

Hello mate

Thanks for your help. I already did it and it's working properly

• ###### Re: Set analysis not working - Ignore selections

Also ignore selection in variable

Max({1}date(date_variable))

It might help

• ###### Re: Set analysis not working - Ignore selections

Also,

sum({1<[date_variable] = {'\$(=maxdate)'}>} A)

or in maxdate: =max(date([date_variable]))

by the way:

a line based set sxpression (if you want to calculate max(date) in each line of your table chart), won't work. For that you need another solution, so check your needs.

Regards

• ###### Re: Set analysis not working - Ignore selections

Hi Daniel,

sum({1}{<[date_variable] = {\$(maxdate)}>}[A])

Regards

Sathish

• ###### Re: Set analysis not working - Ignore selections

you have to specify the identifier also in your variable as below:

=sum( {1< [date_variable] = {"=max({1}date([date_variable]))"}>} [A] )

• ###### Re: Set analysis not working - Ignore selections

Hello Andrea!!That was the problem!!I had to do the same in the max variable!!

Thank you very much for your help!