topic Re: sum in condition in QlikView

sum in condition

Thu, 09 Oct 2014 09:17:12 GMT

is there any syntax error with this expression? qlikview doesn't underline it but it always returns 0.

i want to say that if Sum(Dif) is more that zero, the order Id should be counted.(for any Order Id there are some Difs)

Count ( Distinct if ( (sum([Dif])>0), [Id Order] ) )

anbu1984 — Thu, 09 Oct 2014 09:20:09 GMT

Count ( Distinct if ( (Aggr(sum([Dif]),your_dim)>0), [Id Order] ) )

Anonymous — Thu, 09 Oct 2014 09:20:58 GMT

try with:

if (sum([Dif])>0, Count(Distinct [Id Order]))

Marc.

sorrakis01 — Thu, 09 Oct 2014 09:21:05 GMT

hI,

Try this =Count(DISTINCT(if(sum([Dif])>0,[Id Order])))

Regards

Thu, 09 Oct 2014 09:29:06 GMT

Dear mana,

Please use the following. expression:-

count({$<Dif={">0"}>}DISTINCT [ID Order])

Thanks & Regards

Prince Anand

Thu, 09 Oct 2014 09:29:17 GMT

thanks

Thu, 09 Oct 2014 09:29:31 GMT

thanks

Thu, 09 Oct 2014 09:29:51 GMT

thanks

Thu, 09 Oct 2014 09:30:16 GMT

thanks.