topic Re: Fractile/Aggr/Sum command in load statement in QlikView

Fractile/Aggr/Sum command in load statement

Mon, 09 Dec 2013 13:38:02 GMT

I have no problem with adding the below statement to a Chart but when I try to use it in the load statement. Here is the command I was wondering if anyone has any idea's:

median (aggr(sum({<AssetName= {"Product Name"}>}X),AcctNum))

Re: Fractile/Aggr/Sum command in load statement

Anonymous — Mon, 09 Dec 2013 13:39:38 GMT

Use an IF statement instead of using set analysis. Set analysis will not work on load scripts.

Re: Fractile/Aggr/Sum command in load statement

Mon, 09 Dec 2013 13:58:11 GMT

So what would it look like. Can you provide me an example.

Re: Fractile/Aggr/Sum command in load statement

Anonymous — Mon, 09 Dec 2013 14:11:00 GMT

You can try something like below.

Median(sum(IF(AssetName = [Product Name], X)))

Use a group by clause and group the records to the same level as you were trying with the AGGR function.

If that does not work properly. then do the SUM in the first load statement and then take the median in another load statement.

Hope that helps.

Regards,

Aadil