topic Re: Sum if in QlikView

Sum if

Wed, 15 Jan 2014 09:36:17 GMT

Hi,

I have created the following expression.

=Num(if(Sum ([Receipt_STK Value]) = Sum ([Sale_STK Value]),0,1))

It does display 0 or 1. But i am unable to show the total i.e. sum of values on Dimensions. I have enabled show partial sums and Sum of Rows

Venu

Re: Sum if

jagan — Wed, 15 Jan 2014 09:52:49 GMT

Hi,

Try like this

= Sum(Aggr(if(Sum ([Receipt_STK Value]) = Sum ([Sale_STK Value]),0,1), ChartDim1, ChartDim2, .. ChartDimN))

Regards,

Jagan

Re: Sum if

Wed, 15 Jan 2014 10:00:42 GMT

hi try this

sum(

if(

if(Sum ([Receipt_STK Value]) = Sum ([Sale_STK Value]),0,1),

[Receipt_STK Value]

)

Re: Sum if

Wed, 15 Jan 2014 10:05:14 GMT

Thanks Jagan,

It worked.

I have the following expression in which i do not want to display value which are NULL. But i want to include Zero

=if(((Sum ([CLosing_STK Value]) + Sum ([Intran_STK Value])) / (Sum ([Avg Value])/30)) <=10,(Sum ([CLosing_STK Value]) + Sum ([Intran_STK Value])) / (Sum ([Avg Value])/30))

Regards

Venu

Re: Sum if

jagan — Thu, 16 Jan 2014 01:52:42 GMT

Hi,

Can you attach some sample application and come up with an example, it helps in understanding the scenario easily.

Regards,

Jagan.