How to fetch multiple values from the filter using max function

[siddharthsoam]

Hi

I want to fetch multiple values from month filter where the month is the maximum in a quarter

for ex it should show me data of the maximum month for quarter 2 i.e. Sep, when I select Q1 and Q2 it should show me data for Sep month and June month summed up

[poojashribanger]

Hi,

You can use this expression

max(total MonthName)

[OmarBenSalem]

Create a new dimension as follow:

=aggr(max({$<Month = p({1<Month={"$(=max(Month))"}>})>} Month ),Month)

result:

[siddharthsoam]

Hi Omar

This function is returning me a single value. I want it to return me multiple values for quarter Q2 and Q3 that is 6 and 9.

Also it would be great if we take months filter not in numbers but in as text 1 for Apr and thereafter

[shraddha_g]

Please refer attached..Is this what s required?

[siddharthsoam]

Hi Shraddha that's exactly what I want minus the year

[shraddha_g]

PFA

[siddharthsoam]

Hi Shraddha

I am using the following expression

Concat( distinct { <Quarters=p(Quarters)>} Month(QuarterEnd),',')

but still not able to get the desired result. Its showing nothing on the KPI.

[siddharthsoam]

can you please share the qvf

[shraddha_g]

Do you have QuarterEnd Field Calculated in Backend?

if not,

Concat( distinct { <Quarters=p(Quarters)>} Month(QuarterEnd(DateField)),',')

At the place of DateField use your appropriate DateField