sum in condition

[#1]

hi

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 · Accepted solution]

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

[Anonymous]

try with:

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

Marc.

[sorrakis01]

hI,

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

Regards

[#5]

Dear mana,

Please use the following. expression:-

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

Thanks & Regards

Prince Anand

[#6]

thanks

[#7]

thanks

[#8]

thanks

[#9]

thanks.