Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
jacek_stypulkow
Contributor
Contributor

count new in last 7 days who

Hi,

The below expression should result the counting new customers who appeared over last 7 days.

can you help please to find why the below expression does not work:

count({$<[Customer Name]
={"=min({$<Turnover={'>0'},[Offer Creation Date]={'<=$(=max([Offer Creation Date]))'}>}[Offer Creation Date])>=$(=max([Offer Creation Date])-7)"}>}
distinct [Customer Name])

Thanks 

Jacek

 

2 Replies
sravankumarkaturi

Hi ,

I did not understand first part of section access but I tried with the date range, please try 

count(distinct({$<[Customer Name]={"=min({$<Turnover={'>0'},

[Offer Creation Date]={">=$(=Date(max([Offer Creation Date])-7))<=$(=Date(max([Offer Creation Date])))"}>} [Customer Name]))

 

Thanks

jacek_stypulkow
Contributor
Contributor
Author

Thanks, the expression is still not working. It should count only customers who made turnover in last 7 days for the first time ever.