Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
jorgen_santberg
Contributor III
Contributor III

Count new customers based on criteria

Hi all,

 I am trying to make an expression where new customers are count based on 3 criteria which need to be met:

- no sales in previous year (=2022)

- sales must be more than 1 article

- total sales must be bigger than 20 pieces 

 

The dimensions are customer / article / sales / month / year and I also would like to see the development per month in 2023.

 

Thanks in advance for your help!

Labels (1)
1 Solution

Accepted Solutions
Gabbar
Specialist
Specialist

Count({<Customer=e({<Year={"2022"}>})>*<Customer={"=(Sum(Sales)>20)"}>*<Customer={"=(Count(Article)>1)"}>}distinct Customer)

View solution in original post

1 Reply
Gabbar
Specialist
Specialist

Count({<Customer=e({<Year={"2022"}>})>*<Customer={"=(Sum(Sales)>20)"}>*<Customer={"=(Count(Article)>1)"}>}distinct Customer)