Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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] ) )
Count ( Distinct if ( (Aggr(sum([Dif]),your_dim)>0), [Id Order] ) )
Count ( Distinct if ( (Aggr(sum([Dif]),your_dim)>0), [Id Order] ) )
try with:
if (sum([Dif])>0, Count(Distinct [Id Order]))
Marc.
hI,
Try this =Count(DISTINCT(if(sum([Dif])>0,[Id Order])))
Regards
Dear mana,
Please use the following. expression:-
count({$<Dif={">0"}>}DISTINCT [ID Order])
Thanks & Regards
Prince Anand
thanks
thanks
thanks
thanks.