Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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

1 Solution

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

View solution in original post

11 Replies
ahaahaaha
Partner - Master
Partner - Master

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
Specialist
Specialist
Author

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
Creator III
Creator III

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

Creating a bookmark ‒ Qlik Sense

agigliotti
Partner - Champion
Partner - Champion

you can also use the following extension:

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

to sets predefined values when a sheet being opened.

beck_bakytbek
Master
Master

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
Specialist
Specialist

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

luismadriz
Specialist
Specialist
Author

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
Specialist
Specialist

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

beck_bakytbek
Master
Master

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