Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
luismadriz
Specialist
Specialist

Predefined filters

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,

Luis

11 Replies
tomasz_tru
Specialist
Specialist

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

luismadriz
Specialist
Specialist
Author

Hi, thanks for those ideas. Set expressions were my first attempt to solve it but I think that even if we manage to create complex measures summarising each business scenario sort of correctly, the data in other visualisations will continue to show something that doesn’t go with the business scenario or “filter”.

A this stage, after gaining all the feedback you gurus have provided me and while I get better at Qliking, I’m inclined to move it to the data model and declare it a gap between Qlik Sense and Business Objects. In fact the BO Admin guys have had to move some of the more convoluted filters to the data model to speed things up. Still BO Users will lose the ability to do those filters themselves and they’ll have to rely on IT to do them in Qlik Sense when required.

Thanks for those ideas on bookmarks and extensions, we’ll definitely use them when we get there

Many thanks again for your attention and collaboration

Regards,

Luis