topic Re: Sum if in QlikView

Sum if

Thu, 25 Jun 2015 05:10:21 GMT

Hello Guys,

I am having an issue with a variable which I am creating:

=Sum({<Date={'>=$(=Date(Max(Date)))<=$(=(Date(Max(Date)))'}>}if(ConvDuration>0,1,0))

Actually I need to get the total call of today whereby the conversation duration exceeded 0 seconds.

Thanks for your usual help.

Kind Regards,

Hasvine

PrashantSangle — Thu, 25 Jun 2015 05:31:47 GMT

Hi,

try like

Sum({<Date={'>=$(=Date(Max(Date)))<=$(=(Date(Max(Date)))'},ConvDuration={'>0'}>} 1)

Regards

danieloberbilli — Thu, 25 Jun 2015 05:31:48 GMT

the sum(1) might be the problem, try sth like

SET vVariable = '=Count({<ConvDuration={">0"}, Date={">=$(=Date(Max(Date)))<=$(=(Date(Max(Date)))"}>} CallID))';

Thu, 25 Jun 2015 05:36:06 GMT

Hi Max,

I think in your code there is mistake happen can you check it once.

Ramya.