topic Count difference in QlikView

Count difference

Wed, 22 Oct 2014 15:35:05 GMT

Hi,

I have data and wanted to show count of dates if SoldAmt >0 or NULL. If I select any date and count should not consider the selection like ignoring.

Attached data is the example and count value should be 50, but when I use this function I get 52

=NUMericCOUNT({<WeekDate=>}SoldAmt)

Can you pls suggest.

Thanks,

JonnyPoole — Wed, 22 Oct 2014 16:13:38 GMT

Here is a formula that will work for you:

=sum( {$<WeekDate=>} if (aggr( sum( {$<WeekDate=>} SoldAmt), WeekDate)>0,1))

Wed, 22 Oct 2014 17:29:28 GMT

It is working as expected and good solution.

Thanks,