4 Replies Latest reply: Dec 13, 2016 1:14 PM by Guido Caffa RSS

    Ignore filters

    Guido Caffa

      Hi all, i have this situation

       

      1 colum expresion:

      DesNivArt1

       

      2 colum expresion:

      Count( distinct codcli)


      3 colum expresion:

      (Count( distinct codcli)/

      COUNT({1} DISTINCT ALL codcli))*100

       

      anoVtaCab is a year like 2016 - 2015 - 2014...


      DesNivArt1 is the company that provide me the items I sale... in 2 i know how many clients buy an item of the company... in the 3 colum i know the percent of customers that purchase an item of the company, compare to the total customers i have (all customers)... now i want to know the percent of clients compare to the customers who bought me in the selected year. For example

       

           total clients of "DesNivArt=01"

      -----------------------------------------------------  X 100

      total clients i sale in a year selected

       

      qlik.pngqlik2.png