Count of text in a cell - ignoring nulls

[#1]

Hi,

I am a qlikview newbie and hope someone can help with the following query.

I have a table of information which looks like;

Customer	Code	Date sold
A	XXX	01 - 01 - 2012
A	XXX	01 - 03 - 2012
B	YYY
B	ZZZ	01 - 04 - 2012
C	YYY	01 - 04 - 2012

How can I write an expression which is gives the count of product, per customer, based on the date sold. Each line indicates a quantity of 1

I need the count to ignore any null / blank values.

Many thanks,

[Gysbert_Wassenaar · Accepted solution]

count({<[Date sold]={'*'}>} Code) should work (if your field names are "Date sold" and "Code").