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

[deepakqlikview_123]

Hi Kush,

Now req is little bit varied,

When Q4 for FRQ type A is present then show Q4 for A.

When Q4 for FRQ type A is not present then show Q4 for FRQType Q.

When Q4 for FRQ type Q is not present then show Q3 for FRQType Q.

When Q3 for FRQ type Q is not present then no values should display.

is below logic is right

=if(isnull(Avg({<INDICATOR_NAME={'% of Non-Bank Private Debt to Nominal GDP'},FRQ_TYPE={'A'}>}INDICATOR_VALUE)) or

Avg({<INDICATOR_NAME={'% of Non-Bank Private Debt to Nominal GDP'},FRQ_TYPE={'A'}>}INDICATOR_VALUE)=0,

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

if(isnull(Avg({<INDICATOR_NAME={'% of Non-Bank Private Debt to Nominal GDP'},FRQ_TYPE={'Q'},QUARTER={'Q4'}>}INDICATOR_VALUE)) or

Avg({<INDICATOR_NAME={'% of Non-Bank Private Debt to Nominal GDP'},FRQ_TYPE={'Q'},QUARTER={'Q4'}>}INDICATOR_VALUE)=0,

Avg({<INDICATOR_NAME={'% of Non-Bank Private Debt to Nominal GDP'},FRQ_TYPE={'Q'},QUARTER={'Q3'}>}INDICATOR_VALUE),

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

))

Can you please suggest on this

[Kushal_Chawda]

Please find the attached

[deepakqlikview_123]

Hi Kush,

It seems condition is not working properly when there is need to show data for Q3 for frq type Q.

Thanks.

[Kushal_Chawda]

Glad that i was able to help

[deepakqlikview_123]

Hi Kush,

It seems condition is not working properly when there is need to show data for Q3 for frq type Q.

Thanks

[Kushal_Chawda]

Can you demonstrate for the same?

[deepakqlikview_123]

whenever i am using data for Q for Q3 it is not showing in chart i have attached sample data for the same

[Kushal_Chawda]

Can you tell me for which year and for which INDICATOR_NAME there is issue?

[deepakqlikview_123]

plz chk  indicator % of Non-Bank Private Debt to Nominal GDP 2009 FRQ type Q Quarter Q3 in my new data

[Kushal_Chawda]

I have modified the expression bit.

See the attached