Current quarter in bar chart

[arulsettu]

hi,

     i am having a bar chart with month dimension and in expression set analysis Quarter = Q4 it showing

oct,nov,dec. but i need if select another quarter the month should change according to the quarter

plz suggest some ideas

thanks

[MK_QSL]

Provide your expression please...

[arulsettu]

here it is

=sum({<ACNT_FLEX_01={'Expenses'},Td_Quarter={'Q4'},ACNT_FLEX_03={'Operative and administrative expenses'},TD_DRCR_FLAG={'D'}>}TD_AMT_LC_1)-sum({<ACNT_FLEX_01={'Expenses'},Td_Quarter={'Q4'},ACNT_FLEX_03={'Operative and administrative expenses'},TD_DRCR_FLAG={'C'}>}TD_AMT_LC_1)

[MK_QSL]

You have kept Q4 as static.. You need to make it dynamic by keeping Quarter = max(Quarter) or

QuarterStart(Date) and QuarterEnd(Date)... with combination of AddMonths function..

[arulsettu]

max(quarter) is not working can you tell me how to do with quarterstart and end

[arulsettu]

any ideas

[rubenmarin1 · Accepted solution]

Hi Arul, instead of "Td_Quarter={'Q4'}" you can use:

Td_Quarter={'$(=MaxString(Td_Quarter))'}

If you want more than one quarter use something like:

Td_Quarter={'$(=Concat(Td_Quarter, Chr(39) & ',' & Chr(39)))'}

[arulsettu]

thanks Ruben i will check

[#9]

Hey Arul ,

Try like this.....

dual('Quarter ' & ceil(month(Field)/3), ceil(month(Field)/3))AS DateFieldQuarter

or

'Q' & ceil(month(field)/3)

[arulsettu]

Hi Ruben,    

               if i select Q1 i am getting jan feb mar oct nov dec. i want jan feb mar that mean Q1 only

thanks