Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
When sheet is activated, I want to default field "Year" to Current Year Variable.
Field = Year
Variable = _SySCurrentYear
Can someone suggest how to do this?
Hi,
I suggest you do this like
Field = Year
Variable = Year(Yearstart( Today( ) ) )
Rgds
Anand
Hi,
Or you can directly assign if there is field Year like
Field = Year
Variable = Year
Rgds
Anand
where should i assign this? i want this filter to be applied only for 1 chart on 1 sheet and not for rest of the sheets
Hi,
Use this variable only on single sheet or single chart.
Rgds
Anand
If you only want this to affect a single chart, you probably don't want to make any selections. Instead, you'll probably want set analysis. As an example, say your chart has an expression of sum(Sales). To restrict this to only the current year based on your variable, you might use an expression like this.
sum({<Year*={'$(_SySCurrentYear)'}>} Sales)
The exact expression may depend on how your field and variable are defined, though.