Predefined filters

[luismadriz]

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

[ahaahaaha]

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]

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]

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

Creating a bookmark ‒ Qlik Sense

[agigliotti]

you can also use the following extension:

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

to sets predefined values when a sheet being opened.

[beck_bakytbek]

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]

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

[luismadriz]

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

Cheers,

Luis

[tomasz_tru]

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]

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