Qlik Community

Qlik Sense Enterprise Documents & Videos

Documents & videos about Qlik Sense.

Filters on Set Analysis part 2

Partner
Partner

Filters on Set Analysis part 2

We will go into more features from the filters, if you are just beginning, go to:

Filter on set analysis

Now, after knowing how a filter works, we can now do something more.

first:

How to use more than one filter?

it is easy, just add a comma and it is all worked out.

=sum({<Sales={"sales>100"},Fruit={'Apple'}>}  Sales)

this will filter the sales higher than 100 from our database and also only get the fruit Apple.

If we want to lock this filter to not change even if a global filter is on, you do something like this:

=sum( {  1  <Sales={"sales>100"},Fruit={'Apple'}>}  Sales)


this number "1" on the beginning will lock all filters except for the ones ahead. So, in this way even if you filter something on the global filter, it will not change this function.

If you like it let me know, i will keep posting tips if you keep supporting!

Like, share, bookmark is you think it deserves!

Thanks

Version history
Revision #:
1 of 1
Last update:
‎2018-08-24 12:32 PM
Updated by: