exclude , not in - qlikview

[#1]

Hi all,

I have a sales orders database, and I neet to extract some informations, regarding the customers.

My expression in the chart looks like :

= count({<YearOrder={'2017'},Category={'Fert','CP','Seeds'}>} DISTINCT CustomerCode)

This returns the no of customers from YearOrder 2017 based on those 3 category.

I have the following issue , if I want to return let's say the "New customers" meaning all the customers who bought in the Year Order 2017, and didin't bought from Year Order 2015 and 2016, how the expression would look like ?

Thank you!

[sunny_talwar · Accepted solution]

May be this

=Count({<CustomerCode = P({<YearOrder={'2017'}>})-P({<YearOrder={'2015', '2016'}>})>} DISTINCT CustomerCode)

[#3]

Hi Sunny, ty for your reply. I will let you know if it works.

Many thanks