Count if based on sum

[#1]

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

• no money at the beginning of year: Sum({<xDATE ={'1.1.2014'}>}xEUR)=0
• but have it now: Sum({<xDATE ={'11.6.2014'}>}xEUR)>0

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?

[tresesco · Accepted solution]

Try:

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

[#3]

Thanks! It actually makes more sense now.