Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Load Statement Help

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

1 Solution

Accepted Solutions
Not applicable

Re: Load Statement Help

I am asking about actual source data in the tables.

3 Replies
Not applicable

Re: Load Statement Help

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.

Not applicable

Re: Load Statement Help

A sample of the data load above would be:

                                                   EF4_Value

CommunityCollege                           50%

HE                                                    60%

Public-K12                                        70%

Charter                                             74%

Does this make sense?

Not applicable

Re: Load Statement Help

I am asking about actual source data in the tables.

Community Browser