Set Analysis Difference between 8.5 and 9.0

amars — Wed, 05 Jan 2011 16:04:17 GMT

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 — Wed, 05 Jan 2011 16:28:17 GMT

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

topic Re: Set Analysis Difference between 8.5 and 9.0 in QlikView

Set Analysis Difference between 8.5 and 9.0

Re: Set Analysis Difference between 8.5 and 9.0