Announcements
cancel
Showing results for
Did you mean:
Creator III

2015 and beyond data only

Hi All,

I have this expression =count(year([Medal.Won/Lost Date])>='2015') and I want it to show only the data from 2015 and beyond but when I 'clear all', its originates back to all the data from previous years too.

What am I doing wrong? Do I need to set >= 2015 parameter in the dimensions rather than the expression? Thanks in advance.

1 Solution

Accepted Solutions
Specialist

Hi,

You can create a Calculated Dimension. If(year='2015','2015')

And expression count(medal won/last date)

But if you like always show the year youn need to use set analysis and use parameter 1.

Count(1{<Year={'2015'}>}medal won/last date)

Regards

4 Replies
Champion

Hi Stephen,

sorry, I don't quite understand your scenario - is this an expression in a chart?

Then it should be independent of selections and when you click "Clear all", that should not affect your chart?`

(that said, to ´promote user_friendliness, I would suggest not putting any limitation in either the chart_dimension nor the chart_expression, but to use an automatic selection (upon opening the sheet) to activate that.

HTH

Creator III
Author

Hi DN,

Thanks for the reply and I am not familiar with the automatic selection function.

My query is an expression in a straight table and when I 'clear all', my data will show from 2003 to 2020 instead of 2015 to 2020.

Specialist

Hi,

You can create a Calculated Dimension. If(year='2015','2015')

And expression count(medal won/last date)

But if you like always show the year youn need to use set analysis and use parameter 1.

Count(1{<Year={'2015'}>}medal won/last date)

Regards

MVP

Hi

Try like this

Year as Dimension

exp:

If(isnull(Getcurrentselections()), count(Exp) , Count({<Year = {">=2015"}>}Exp))

isnull(Getcurrentselections()) is return null, when there is no selection in any field. suppose your expression need to based on any particular field, then change like this

= if(GetselectedCount(FieldName) = 0, count(Exp) , Count({<Year = {">=2015"}>}Exp))

Thanks & Regards, Mayil Vahanan R