topic Re: correct Sum in QlikView

correct Sum

Tue, 25 Mar 2014 18:49:54 GMT

Hi all! I have the following table in QV

when Oklad =

if(Column(1)>0,Sum(If(vDate_2>=DateStart2 and (isNull(DateEnd2) or DateEnd2> vDate_2), Oklad)))

The results I want is:

In other words, I want to get the correct Sum. Help me, please.

Re: correct Sum

Tue, 25 Mar 2014 19:00:31 GMT

Hi,

You can may be use dimensionality() function and use distinct when calculating for Totals and for the others just use the normal expression.

Re: correct Sum

Anonymous — Tue, 25 Mar 2014 19:08:58 GMT

I suspect that the condition Column(1)>0 is the source of the problem. It may be false for a single row which will be hidden, but the total >0, hence the values of Oklad included in total. Try to think of a different condition. Or, maybe this, moving this condition inside sum:

Sum(If(Column(1)>0 and vDate_2>=DateStart2 and (isNull(DateEnd2) or DateEnd2> vDate_2), Oklad))

Re: correct Sum

Wed, 26 Mar 2014 07:30:48 GMT

Michael, Sum(If(Column(1)>0 and vDate_2>=DateStart2 and (isNull(DateEnd2) or DateEnd2> vDate_2), Oklad)) - wrong.

Get all 0,00 (

Re: correct Sum

PrashantSangle — Wed, 26 Mar 2014 07:36:13 GMT

Hi,

Try This,

if(Column(1)>0,If(vDate_2>=DateStart2 and (isNull(DateEnd2) or DateEnd2> vDate_2),Sum(Oklad)))

Regards

Re: correct Sum

Wed, 26 Mar 2014 07:42:56 GMT

Hi, if(Column(1)>0,If(vDate_2>=DateStart2 and (isNull(DateEnd2) or DateEnd2> vDate_2),Sum(Oklad))) get all -

Re: correct Sum

PrashantSangle — Wed, 26 Mar 2014 07:45:55 GMT

Hi,

Then you can use Aggr()

if(Column(1)>0,If(vDate_2>=DateStart2 and (isNull(DateEnd2) or DateEnd2> vDate_2),Aggr(Sum(Oklad),Work,Stavki))

Regards,

Re: correct Sum

jonathandienst — Wed, 26 Mar 2014 08:03:31 GMT

You could try

if(Column(1)>0,

Aggr(

Sum(If(vDate_2 >= DateStart2 and (isNull(DateEnd2) or DateEnd2 > vDate_2), Oklad))

, DateStart2, DateEnd2, Work, Organization

, Subdivision1, Subdivision2, Subdivision3, Subdivision4, Subdivision5, Subdivision6

)

The chart dimensions need to be included in the Aggr()

HTH

Jonathan

Re: correct Sum

Wed, 26 Mar 2014 14:38:34 GMT

Stavki =

=SUM(If(vDate>=DateStart and (isNull(DateEnd) or DateEnd> vDate),Stavki))

The correct answer:

Oklad =

Sum(Aggr(if(SUM(If(vDate>=DateStart and (isNull(DateEnd) or DateEnd> vDate),Stsvki))>0,

Sum(If(vDate_2>=DateStart2 and (isNull(DateEnd2) or DateEnd2> vDate_2), Oklad))),Organization,Subdivision1,Subdivision2,Subdivision3,Subdivision4,Subdivision5,Subdivision6, Work))

all thanks! 😃