topic Re: Requirement For quarterly data on yearly basis in QlikView

Requirement For quarterly data on yearly basis

deepakqlikview_123 — Thu, 18 Jun 2015 15:57:01 GMT

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

Re: Requirement For quarterly data on yearly basis

jagan — Fri, 19 Jun 2015 04:13:50 GMT

Hi Deepak,

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

Regards,

Jagan.

Re: Requirement For quarterly data on yearly basis

deepakqlikview_123 — Fri, 19 Jun 2015 04:27:55 GMT

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

Re: Requirement For quarterly data on yearly basis

aveeeeeee7en — Fri, 19 Jun 2015 04:47:32 GMT

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

Re: Requirement For quarterly data on yearly basis

deepakqlikview_123 — Fri, 19 Jun 2015 07:24:52 GMT

Hi,

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

thanks

Re: Requirement For quarterly data on yearly basis

aveeeeeee7en — Fri, 19 Jun 2015 07:29:06 GMT

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

Re: Requirement For quarterly data on yearly basis

Kushal_Chawda — Fri, 19 Jun 2015 07:41:00 GMT

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

Re: Requirement For quarterly data on yearly basis

Kushal_Chawda — Fri, 19 Jun 2015 08:01:47 GMT

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

Re: Requirement For quarterly data on yearly basis

deepakqlikview_123 — Fri, 19 Jun 2015 09:00:21 GMT

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

Re: Requirement For quarterly data on yearly basis

Kushal_Chawda — Fri, 19 Jun 2015 09:05:29 GMT

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

Re: Requirement For quarterly data on yearly basis

deepakqlikview_123 — Fri, 19 Jun 2015 09:25:08 GMT

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

Re: Requirement For quarterly data on yearly basis

Kushal_Chawda — Fri, 19 Jun 2015 09:27:38 GMT

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

Re: Requirement For quarterly data on yearly basis

jagan — Fri, 19 Jun 2015 09:27:59 GMT

Hi,

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

Regards,

Jagan.

Re: Requirement For quarterly data on yearly basis

deepakqlikview_123 — Fri, 19 Jun 2015 09:46:25 GMT

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

Re: Requirement For quarterly data on yearly basis

Kushal_Chawda — Fri, 19 Jun 2015 09:57:56 GMT

Please see the attached

Re: Requirement For quarterly data on yearly basis

deepakqlikview_123 — Fri, 19 Jun 2015 10:32:24 GMT

Thanks Kush

it works

Re: Requirement For quarterly data on yearly basis

deepakqlikview_123 — Mon, 13 Jul 2015 09:09:44 GMT

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

Re: Requirement For quarterly data on yearly basis

Kushal_Chawda — Mon, 13 Jul 2015 09:56:14 GMT

Please see the attached

Re: Requirement For quarterly data on yearly basis

deepakqlikview_123 — Mon, 13 Jul 2015 10:11:36 GMT

Hi Kush

there is no attachment

thanks

Re: Requirement For quarterly data on yearly basis

Kushal_Chawda — Mon, 13 Jul 2015 10:13:28 GMT

Can you see now?