Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Sum if

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

3 Replies

Re: Sum if

Hi,

try like

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

Regards

Regards,
Prashant Sangle
danieloberbilli
Valued Contributor II

Re: Sum if

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

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

Not applicable

Re: Sum if

Hi Max,

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

Ramya.

Community Browser