Functions within Set Analysis

[martynlloyd]

In a chart expression I select the quarter to which the SELECTED month belongs:

=QuarterName(MakeDate(KPIYear,KPIMonth))

Will give me the quarter name in a column - I now need to calcuate the amount -

sum({$<KPIMonth=, Quarter={'Jul-Sep 2014'} >} TRPActual)

Works OK, but I need the 'Jul-Sep 2014' to be dynamic, based on the selected year and month (KPI...).

What is the correct syntax for the set analysis statement?

Many thanks,

M.

[alexandros17 · Accepted solution]

try this and let me know

sum({$<KPIMonth=, Quarter={'$(=QuarterName(MakeDate(KPIYear,KPIMonth)))'} >} TRPActual)

[martynlloyd]

Brilliant!

I had missed the quotes around the dollar expansion.

Many thanks!

M.

[Anonymous]

Hi,

You can make a variable like

v_quarter=QuarterName(MakeDate(KPIYear,KPIMonth))

and use that variable in set analysis which is as follows :

sum({<$(v_quarter)={"*"}>}TRPActual)

Hope it helps.

Thanks,

Geeta