Requirement For quarterly data on yearly basis

[deepakqlikview_123]

hello all,

below is scenario

As per requirement if FRQ_Type is A then i need to show Q4 data for FRQ_TYPE A year,otherwise need to put Q4 data for FRQ type Q for  year

can you please suggest how to calculate data on yearly basis at backend.

as per requirement i need to show above data on stacked bar chart.

please find my attached sample data for this

please suggest on this

[jagan]

Hi Deepak,

I am not clear about the requirement, can you explain with a sample values and your expected output.

Regards,

Jagan.

[deepakqlikview_123]

suppose i have year 2013 and have FRQ_Type  both A and Q then in that case i need to show Q4 value for FRQtype A for 2013.

if FRQ type A is not there in any of year then only in that case i need to show Q4 value for FRQ type Q(if FRQ type A is not there)

the sample data whatever i have attached contains both FRQ type A and Q i need to show indicator value for indicator name in stacked bar chart for all 3 indicators for respective years as per above scenario.

thanks

[aveeeeeee7en]

Hi

Try these Expressions:

% of Non-Bank Private Debt to Nominal GDP:
=if(GetSelectedCount(YEAR)>=1,Avg({<INDICATOR_NAME={'% of Non-Bank Private Debt to Nominal GDP'},FRQ_TYPE={'A'},QUARTER={'Q4'}>}INDICATOR_VALUE),
Avg({<INDICATOR_NAME={'% of Non-Bank Private Debt to Nominal GDP'},FRQ_TYPE={'Q'},QUARTER={'Q4'}>}INDICATOR_VALUE))

% of Bank Private Debt to Nominal GDP:
=if(GetSelectedCount(YEAR)>=1,Avg({<INDICATOR_NAME={'% of Bank Private Debt to Nominal GDP'},FRQ_TYPE={'A'},QUARTER={'Q4'}>}INDICATOR_VALUE),
Avg({<INDICATOR_NAME={'% of Bank Private Debt to Nominal GDP'},FRQ_TYPE={'Q'},QUARTER={'Q4'}>}INDICATOR_VALUE))

Hope, it meets your requirement.

Regards

Av7eN

[deepakqlikview_123]

Hi,

Thanks for response but it is not working as per requirement.

thanks

[aveeeeeee7en]

What would be the exact Output required by you???

[Kushal_Chawda]

But FRQtype A is available in all years so there will be values for FRQtype A and quarter Q4 for all years

[Kushal_Chawda]

if there is no value for FRQtype A then we need to display value for FRQtype Q and Quarter Q4  but what if values for FRQtype Q and Quarter Q4 value is not available.. in this case what will be value to be displayed

[deepakqlikview_123]

lets take an example

	FRQTYPE	Quarter
2012	A	Q4	20
	Q	Q1
	Q	Q2
	Q	Q3
	Q	Q4
2013	Q	Q1
	Q	Q2
	Q	Q3
	Q	Q4	30

in above scebnario

For 2012 Data shpuld be Q4 for FRQ type A

for 2013 data should be Q4 for FRQ type Q

data sholud be like this for all

[Kushal_Chawda]

In your sample for Year 2014 There no values for Q4 for both the FRQtype