showing data quarterly and yearly as per max year and FRQ type

[deepakqlikview_123]

Hello All,

I have data having two frequency types,

FRQ_TYPE Q(Quarterly) and FRQ_TYPE A(Annually)

For all years except max year i need to show data Annually(FRQ TYPE A).

For MAx year as per indicator name below are conditions.

1. if my max year is 2014 and if i have quarterly data for FRQ type Q for Q1, Q2, Q3,Q4

then i need to show all quarterly data for FRQ type Q for 2014 as well as data for FRQ_TYPE A for 2014

2.if my max year turns into 2015 then i need to display data for FRQ_TYPE A for 2014 and for 2015 FRQ_TYPE

Q for Q1

3. if max quarter for FRQ type Q is Q4 for max year then need to show data for both FRQ type A and Q(annually and quarterly)(5 bars)

I have attached sample data and application for the same

4Selection should be dynamically, if i select year 2012 and 2013  in this case max year would be 2013 in this case i need to show data for 2012 annually(FRQ type A) and for 2013 (data should be FRQ type A and FRQ type Q(Q1,Q2,Q3,Q4) 5 bars

Thanks

[deepakqlikview_123]

Hi All,

Can you please suggest on this.

Thanks

[jagan]

Hi Deepak,

It is not possible?  Is there any restriction like user can select only this many Years?

Regards,

Jagan.

[deepakqlikview_123]

Hi Jagan,

There is no such restriction but data should be as per FRQ type for any of max year in default selection as well as dynamic selection.

Moreover in  your logic value for max year is showing incorrectly.

thanks

[jagan]

Hi Deepak,

Then it is very very difficult.

Regards,

Jagan.

[deepakqlikview_123]

Hi Jagan,

Is it possible to fill up above requirement by using set analysis.

Thanks

[jagan]

Hi,

It is like combining two dimensions into one, will try and let u know.

Regards,

jagan.

[deepakqlikview_123]

Hi Jagan

Can you please suggest on this

Thanks

[settu_periasamy]

Hi,

Try to combine the dimension into one as suggested by Jagan.

do you want like the below screen?

If so, check the attachment. may be give the idea.

[deepakqlikview_123]

Hi Settu,

For any max year i need to show data for FRQ type A as well as FRQ type Q.

For example if my max year is 2014 then there should be 5 bars.

1 is for FRQ type A(annually)  and 4 bars for FRQ type Q(Q1,Q2,Q3,Q4 for Q4) and this selection should be dynamically.

if user selects year 2012 and 2013 in this case my max year will be 2013 till 2012 it will show data for FRQ type A and for 2013

there should be 5 bars.

1 is for FRQ type A(annually that is also present in Q4 for FRQ type A)  and 4 bars for FRQ type Q(Q1,Q2,Q3,Q4 for Q4)

thanks