Set Analysis Difference between 8.5 and 9.0

[amars]

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.,

[Miguel_Angel_Baeyens]

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