Count value smaller or bigger then

[#1]

Hi all,

I am pretty new to qlikview and just finished the designer course. Now I am trying to calculate the number of members on an certain date (variabel) but I have no clue how to make this expression...

What I want to calculate is:

Count MemberNumber

salesdate < variabel1

validuntill > variabel1

Could anyone help me how I should make this into a working expression? So far I didn't find it in the manual...

Regards,

Dennis

[#2]

Try:

Count(if(salesdate<variable1 and validuntil>variable1,MemberNumber))

[#3]

Works perfect! thanx!