topic Re: exclude , not in - qlikview in QlikView

exclude , not in - qlikview

Tue, 25 Apr 2017 10:57:20 GMT

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!

Re: exclude , not in - qlikview

sunny_talwar — Tue, 25 Apr 2017 16:10:32 GMT

May be this

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

Re: exclude , not in - qlikview

Wed, 26 Apr 2017 06:25:50 GMT

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

Many thanks