Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
i_linkov
Contributor
Contributor

Apply a filter without Filter pane

Hello, i'm new and I have a huge blocking point ... I hope someone will be able to help me.

I would like to know, if it possible to apply multiple filters on a table without adding a filter pane

My example :

Table_1

{cars

dogs

cats}

I want to apply a filter with

cars = 1,

dogs between 5 and 10

and cats not equal to 3

Only one time, before extracting or just after extracting BEFORE creating my Sheet.

Do you thing there is a way to do it ?

Thank you very much for your time.

1 Reply
sunny_talwar

May be use set analysis here

Assuming your expression is Sum(Measure), try this

Sum({<cars = {1}, dogs = {'>=5<=10'}, cats -= {3}>} Measure)