Hi, SAP Business Objects allows the creation of predefined filters. Those predefined filters are basically a combination of conditions for the data that will be shown. These conditions are together using different logical operators and priorities. For example, (Country = 'US') or (('Argentina' and AGE >= 30) or Visa = 'Granted') or any combination that might make business sense... not like the one I just wrote. These filters are usually created to allow quicker reporting and they are named after the business scenario. A regular filter is around 5-10 conditions. We talking about around 40 dimensions, 15 measures and possibly around 10 filters
Is there any equivalent of this in Qlik Sense?
or is it something to be done during data preparation?
We're not developing anything in Qlik Sense yet but I'm doing a gap analysis to see what sort of features may be missed when we migrate, or what are the possible workarounds.
I value your thoughts, many thanks,
Solved! Go to Solution.
Here's example how to control set analysis formulas from the load script, and use it to switch between complicated selections. You will need to read something on set analysis (ex. http://help.qlik.com/en-US/sense/3.2/Subsystems/Hub/Content/ChartFunctions/SetAnalysis/set-analysis-...)
You can unload all the information without filtering from SAP to Qlik Sense and then apply all the power of the Qlik engine for selection and filtering virtually any data.
Thanks for your prompt reply Andrey! We definitely will be loading all data unfiltered, the question is how to replicate (or workaround) the need for a complex business filter as described above that can't be achieved with just few clicks and selections, but with a more complex logical statement
Hi, thanks all for taking the time to respond and we're definitely going to use your suggestions. Unfortunately for us the business filters are more complex than a pure selection of values in existing dimensions as there could be a different combination of logical operators. For example, please see the image attached from Business Objects of a made-up filter
In Qlik Sense, or in any regular filter selection unless built for another purpose, the default logical operator for selections within a dimension is "OR" and to combine several dimensions the default operator would be "AND". Let's say I select "Colombia" and "Venezuela" from the list of countries and I also select "Female" from the dimension gender, the resulting where clause in a query would be (Country = “Venezuela” OR Country = “Colombia”) AND (Gender = "Female") or something practically similar. I hope I'm not making a "Storm in a Teacup" or as we would say in Venezuela, "drowning in a glass of water" .
i have an idea, you can use in script area: Sub and Call function (in that way you can select certain data) and the half of your idea you can select like a filter on UI (Userinterface)
What do you think about it? Becase it is not possible to create the above (your) filter on Userinterface