Can we put condition in max function

[siddharthsoam]

Hi

I want to apply a condition in max function.

Max({<[Fiscal Year]='FY16'>}( mid(Quarters,2)))

Ideally it should give me 4, but its not returning any value.

[siddharthsoam]

What is this part used for in the expression?

[shraddha_g]

Nulify the selections in order to avoid its effect and to make expression work according to Set analysis part

[siddharthsoam]

I am facing little discrepancy in the data. When I select quarter 2, it is showing me total service_rev as 22.62 in previous tab i.e. data for Q1, but when I select quarter1 in  filter it shows me 23.33 in the recent tab.

Filter selection quarter-Q1 Fiscal Year-2017

Filter selection quarter-Q2 Fiscal Year-2017

[shraddha_g]

I can see that table are referring to Recent Months & Previous Months

You need to check table with Recent Quarter and Previous Quarter

[shraddha_g]

PFA

[siddharthsoam]

Hi Shraddha,

Sorry for replying late.

Actually I want a like to like comparison for example if  only i select  fiscal year, it should show me the previous fiscal year under the previous tab. If I select a quarter suppose Q2 it shuld show me Q1 under previous. Likewise for months ,but if I select quarter and months simultaneously example Q2 and August , then data for Q1 and May should be reflected under previous.

This functionality should work on multiple selections as well.

[shraddha_g]

It will work that way only

[siddharthsoam]

Can we use mid function in max ex-

max({<fiscal_year={'FY'&(mid(fiscal_year,2)-1)}>}quarter)

I am getting an error doing so

[shraddha_g]

Try

max({<fiscal_year={"$(=Maxstring(fiscal_year))"}>}quarter)

[siddharthsoam]

This expression is working well, but I cannot use it in the following condition. I have embedded the expression in max_quarter.

concat( distinct if(mid(Quarters,2)=1,$(maxQuarter)),',')