topic AW:Re: Doubt in sum( ) function in QlikView

Doubt in sum( ) function

sunil2288 — Fri, 02 Jul 2010 08:25:25 GMT

Hi Everybody,

I have doubt on sum( ) function.below there is an expression written. in this exp if "#_ClaimsAmount" is not available for @_HFM_Code_Group='P0300000' then it should show the sum of "sum(#_NetSalesValue)+sum(#_Amount_Fixed_Cost)" for @_HFM_Code_Group='P0300000' .

but it is not showing like that instead it shows nothing...

=Sum({$<@_HFM_Code_Group='P0300000'>}(sum(#_ClaimsAmount)+sum(#_NetSalesValue)+sum(#_Amount_Fixed_Cost)))

Please resolve this problem..

waiting for response

Thanks,

Sunil

Doubt in sum( ) function

Fri, 02 Jul 2010 08:31:33 GMT

=Sum({$<@_HFM_Code_Group='P0300000'> -1}

I think, not sure though.

AW:Re: Doubt in sum( ) function

brenner_martina — Fri, 02 Jul 2010 08:42:27 GMT

Hi,

there is a mistake between ...>}(sum(... - waht does that mean?

=Sum({$<@_HFM_Code_Group='P0300000'>}(sum(#_ClaimsAmount)+sum(#_NetSalesValue)+sum(#_Amount_Fixed_Cost)))

AW:Re: Doubt in sum( ) function

johnw — Sat, 03 Jul 2010 00:45:05 GMT

I have no clue what you're trying to do. However, in set analysis, the literal value needs to be in curly brackets, like this:

={'P0300000'}

You also can't do a sum() inside of a sum(), or at least not without an aggr(), which probably isn't what you're trying to do anyway.

Doubt in sum( ) function

Sat, 03 Jul 2010 02:04:11 GMT


if(@_HFM_Code_Group='P03000000',if(#_ClaimsAmount>0,#_ClaimsAmount,(sum({$<@_HFM_Code_Group={'P03000000'}>} #_NetSalesValue)+sum({$<@_HFM_Code_Group={'P03000000'}>} #_Amount_Fixed_Cost))),#_ClaimsAmount)

Will do quite literally what you have described but in agreement with John, i don't think we have enough information to determine if it's what you /need/

Without knowing your dimensions i can't tell if you need the set anaylsis or the sums as i don't know what you are grouping by but i ahve included them so you can get handle on the syntax