How to change label name dynamically

[Lucky1]

Hi I want to show my label name as per the quarter. I am using below expression to show current quarter year in the label.but it is giving error. please help on this.

if(Closed_QuarterSerial={'$(=Maxstring(Closed_QuarterSerial))'}),Closed_Quarter_Year)

[Mark_Little]

Hi there, 

I beleive if you are using an IF in a dynamic dimension name you don't have to follow the Set analysis syntax. Try

if(Closed_QuarterSerial=Maxstring(Closed_QuarterSerial),Closed_Quarter_Year)

[Lucky1]

Hi Mark Tried if(Closed_QuarterSerial=Maxstring(Closed_QuarterSerial),Closed_Quarter_Year)

no luck it is giving null -

[vinieme12 · Accepted solution]

What is the format of the field Closed_QuarterSerial ??

Alternative you can try

CurrentQuarter

= Maxstring({<Datefield={'$(=Date(Max(Datefield)))'}>}Closed_QuarterSerial)

PreviousQuarter

= Maxstring({<Datefield={'$(=quarterStart(Max(Datefield),-1))'}>}Closed_QuarterSerial)

replace Datefield with your actual datefield name

[Lucky1 · Accepted solution]

Found solution by writing below code

= Maxstring({<Flag={0}, Closed_QuarterSerial= {"$(=Maxstring([Closed_QuarterSerial]))"}>}Closed_Quarter_Year)