topic Count if based on sum in QlikView

Count if based on sum

Wed, 11 Jun 2014 11:02:25 GMT

Hi,

I am new to QlikView and trying to solve following problem:

I want to calculate the number of persons (=count(DISTINCT PersonID)) that had

Combing those doesn't work:

=COUNT(DISTINCT {<Sum({<xDATE ={'1.1.2014'}>}xEUR)=0 and Sum({<xDATE={'31.12.2013'}>}xEUR)>0>} PersonID)

Does anyone have any suggestions?

tresB — Wed, 11 Jun 2014 11:05:32 GMT

Try:

=COUNT(DISTINCT {<PersonID ={"=Sum({<xDATE ={'1.1.2014'}>}xEUR)=0 and Sum({<xDATE={'31.12.2013'}>}xEUR)>0 ">} PersonID)

Wed, 11 Jun 2014 11:20:16 GMT

Thanks! It actually makes more sense now.