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]

yeah but this is just example how data would need to show on yearly basis.

I have already tried with set analysis but i am not able to get correct result

[Kushal_Chawda]

so what will be the output if both FRQtypes have no values for Q4 that is what I am asking.

[jagan]

Hi,

Why you are not displaying value for 2012, Q4, and FRQTYPE Q?

Regards,

Jagan.

[deepakqlikview_123]

hi all

Data is always for Q4 ,in my newly updated data i have all Q4 are present for all years and

at backend  for FRQ type A value for Q4 is already set for FRQ type Q all quarters are there i need to pick value for Q4 for Q if

FRQ type A is not there otherwise need to plot value for FRQ type A for Q4

thanks

[Kushal_Chawda]

Please see the attached

[deepakqlikview_123]

Thanks Kush

it works

[deepakqlikview_123]

When i am selection quarter Q1,Q2,Q3 expression also still working how to display message as no data to display after selecting those quarter as i am showing data for Quarter Q4

[Kushal_Chawda]

Please see the attached

[deepakqlikview_123]

Hi Kush

there is no attachment

thanks

[Kushal_Chawda]

Can you see now?