2 Replies Latest reply: Apr 26, 2017 2:25 AM by Bogdan Apetrei RSS

    exclude , not in - qlikview

    Bogdan Apetrei

      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!