topic If statement SUM calculation in QlikView

If statement SUM calculation

Fri, 17 May 2013 12:37:39 GMT

Hi I am trying to achieve the following.

i have three companies

000

001

003

000 and 003 share the same database, therefore i recieve double values when running the following sum for company 003. 001 is correct so no need to worry about that.

what i want to do is half the amount for company 003 based on the following calculation.

psuedo if(company = 003......), otherwise ->

Sum(OrderRad.ResterandeBelopp * #Dat_O * OH.Kurs_FSG_act)

Best,Brad

Re: If statement SUM calculation

Fri, 17 May 2013 12:57:50 GMT

try this

if(company = 003,Values*0.5,Values)

Re: If statement SUM calculation

CELAMBARASAN — Fri, 17 May 2013 14:04:59 GMT

Sum(OrderRad.ResterandeBelopp * #Dat_O * OH.Kurs_FSG_act)

I don't get what this expression says

May be for your requirement expression will be

(Sum({<Company={'000', '003'}>} Sales) * 0.5) + Sum({<Company-={'000', '003'}>} Sales)