Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
knightwriter
Creator III
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
sorrakis01
Specialist
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

View solution in original post

4 Replies
datanibbler
Champion
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

knightwriter
Creator III
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.

sorrakis01
Specialist
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

MayilVahanan

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
Please close the thread by marking correct answer & give likes if you like the post.