topic Re: Load Statement Help in QlikView

Load Statement Help

Sat, 21 Dec 2013 17:23:17 GMT

I have tried to move the below calculation being performed in a chart to the load statement of a script and not getting the results I want. What I am trying to do is to eliminate the top 95% and bottom 5% of my numbers to come up with a number. I am sure I need to break it up into a couple of load statements but it is not working. Any ideas will be helpful. Here is the calculation:

avg(Total <Industry>aggr(if(aggr(sum({<AssetName= {"MaintenanceDirect"}>}EF4Value__c),AcctNum)>=

fractile(Total <Industry>aggr(sum({<AssetName= {"MaintenanceDirect"}>}EF4Value__c),AcctNum),.05)

and

aggr(sum({<AssetName= {"MaintenanceDirect"}>}EF4Value__c),AcctNum)<=

fractile(total <Industry> aggr(sum({<AssetName= {"MaintenanceDirect"}>}EF4Value__c),AcctNum),.95),

aggr(sum({<AssetName= {"MaintenanceDirect"}>}EF4Value__c),AcctNum)),AcctNum, Industry))

David

Re: Load Statement Help

Sat, 21 Dec 2013 18:11:55 GMT

You can convert above calculations into script level by using GROUP BY clause and your selections may be limited in you perform the calculations in the script level.

Please post some sample data and desired out put so some one from community will help you.

Re: Load Statement Help

Sat, 21 Dec 2013 19:37:02 GMT

A sample of the data load above would be:

EF4_Value

CommunityCollege 50%

HE 60%

Public-K12 70%

Charter 74%

Does this make sense?

Re: Load Statement Help

Sat, 21 Dec 2013 21:04:08 GMT

I am asking about actual source data in the tables.