Count new records (based on date range criteria)

[jorgie]

Hi to all. 

I try to count in a date range the new registration. I want to calculate, for values >0 the number of customers that got record for the first time.

In excel, by manual handle I get the following data. Note I use Month as dimension

Row Labels	sep	oct	nov
350	203	44	15
351	162	46	31
352	197	39	13
353	76	49	26
355	61	102	17
356	43	102	17
357	0	55	107
Grand Total	742	437	226

In Qlik using date as dimension I get the following result

I need help in order to have the correct results.

Also it would be amazing if I could have the capability to check it in weeks or months by setting a range that find new. For example, ii there wasn't any record 100 days before, is a new one

thanks in advance

[ChannaK]

not sure but you can try this

Count(Distinct {<month={"=Sum(qnty)>0"}>} month)

[jorgie]

did you  check the file?

as you can see the   ---  

=count ( distinct

aggr(

        If( date=min(total <customerq> aggr(if(sum(qnty)>0, (date)),customerq,(date))),

            customerq),customerq,(date)))

gives the closest result. but not the exactly correct.

I am looking for the correct one.

thank you anyway for you time! I appreciate it