1 Reply Latest reply: Nov 4, 2011 4:23 PM by Miguel Angel Baeyens de Arce RSS

    Set Analysis Difference between 8.5 and 9.0

    Michael Jordan

      Hi all,

      Till Date I couldn't understand the difference between set analysis in 8.5 and 9.0 . As per the reference manual "QlikView 8.5, although very powerful, was restricted to stating direct selections in a field. With the new extensions in QlikView 9 it also becomes possible to state selections in a field based on selections in another field. ". I couldn't understand that, if someone can tell me that with and example between what 9.0 can do and 8.5 cannot do. I will be really helpful.

      Thanks in advance.,

        • Re: Set Analysis Difference between 8.5 and 9.0
          Miguel Angel Baeyens de Arce

          Hello,

           

          As far as I understand, Set Analysis in QlikView 8.5 was Field = Value. There were no element P() and E() functions, there were no possible indirect set analysis, meaning that, I'd like to count all EmployeeID values whose customers have bought more than 1K

           

          Count({< EmployeeID = {"=Sum(Sales) > 1000"} >} EmployeeID)
          

           

          EmployeeID is not getting a value in set analysis, but all possible EmployeeIDs that match that function which in turn is based on a different field.

          Or counting EmployeeID whose customers have not bought cars

           

          Count({< CustomerID = E({< Product = {'Cars'} >}) >} EmployeeID)
          

           

          Or all CompanyIDs who are Customers

           

          Count({< CustomerID = P(CompanyID) >} CustomerID)
          

           

          Don't think (haven't tested though) those two were possible in 8.5.

           

          Hope this helps