How to get maximum Quarter based on multiple quarters selection

[nehasaxena]

Hi,

We have chart displays last 8 quarters data. It works well with single quarter selection but when we select more than one quarter it displays as "No data to Display" in chart.

The requirement is to display last 8 quarter based on maximum value from multiple selections of quarter.

Formula in Chart expression:

Sum({<Year=,Quarter=,Month=, Week=,DateType={'Transaction'}, CanonicalDate={">=$(=QuarterStart($(vQtr),-8))<=$(=QuarterEnd($(vQtr)))"}>}NumberofPolicies)

Where vQtr -

If(QuarterNo=1,makedate(Year),If(QuarterNo=2,makedate(Year,04),If(QuarterNo=3,makedate(Year,07),If(QuarterNo=4,makedate(Year,10)))))

Please suggest me how to get the maximum quarter based on multiple value selection.

Regards

Neha

[kaushiknsolanki · Accepted solution]

You will have to modify your variable value.

Try below.

If(Max(QuarterNo)=1,makedate(Year),If(Max(QuarterNo)=2,makedate(Year,04),If(Max(QuarterNo)=3,makedate(Year,07),If(Max(QuarterNo)=4,makedate(Year,10)))))

Regards,

Kaushik Solanki

[sunny_talwar]

Or try this

vQtr = MakeDate(Year, (3*Max(QuarterNo))-2)

[nehasaxena]

Thanks Kaushik, It worked, I didnt knew it was so simple