Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.,
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