Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

luismadriz
Valued Contributor

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

Tags (1)
1 Solution

Accepted Solutions
tomasz_tru
Valued Contributor

Re: Predefined filters

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

11 Replies
ahaahaaha
Honored Contributor

Re: Predefined filters

Hi Luis,

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.

Regards,

Andrey

luismadriz
Valued Contributor

Re: Predefined filters

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

Regards,

Luis

danansell42
Contributor III

Re: Predefined filters

Hi, one solution would be to use the bookmark functionality.

Creating a bookmark ‒ Qlik Sense

agigliotti
Honored Contributor II

Re: Predefined filters

you can also use the following extension:

http://branch.qlik.com/#!/project/59477947a758afec83f4e147

to sets predefined values when a sheet being opened.

beck110979
Valued Contributor III

Re: Predefined filters

Hi Luis,

for such situation i created this solution, look at this:

https://community.qlik.com/docs/DOC-18512

i hope that helps

Beck

tomasz_tru
Valued Contributor

Re: Predefined filters

Maybe integration API could be helpful: App Integration API ‒ Qlik Sense

luismadriz
Valued Contributor

Re: Predefined filters

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 filterFilter.png

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

Cheers,

Luis

tomasz_tru
Valued Contributor

Re: Predefined filters

Is it possible to move the it to the data model - for example additional columns 'is selection 1', 'is selection 2' based on IF condition? Or Set analysis...

beck110979
Valued Contributor III

Re: Predefined filters

Hi Luis,

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

Beck