Skip to main content
Announcements
Qlik Community Office Hours - Bring your Ideation questions- May 15th, 11 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

filtering data for a whole sheet

Hello all,

I need to implement some special case. For example, I have a sheet which contain some charts,tables and which are using one datasource. Each element on the sheet is using it's own expression. But I need to filter the data in a certain way for a whole sheet at once, not only for one element. Is it possible create a statement for a sheet, which will apply only once, and all elements on this sheet will use the filtered data then?

Thanks in advance!

3 Replies
swuehl
MVP
MVP

Not sure what you mean by filtering your data, are you talking of something like a filtering by selecting in fields, e.g. using list boxes?

These should affect all objects by default, if your expressions don't use set expressions or alternate states, which can prevent your objects from being affected.

Does your filter needs to be dynamic i.e. changeable (by user)?

Not applicable
Author

swuehl,

I have some sheets with elements, which are used in production already. And now I want something like a group or namespace, which will be unavailable for user, but this group or namespace should provide something like general pre-assigned filter for initial datasource.

P.S. This filter sholdn't be dynamic one.

erichshiino
Partner - Master
Partner - Master

Hi, Serve

I believe you can use QV 11 Alternate States:

The document and the applications can help explain and demonstrate how to use it:

http://community.qlik.com/docs/DOC-2112

http://community.qlik.com/qlikviews/1194

Regards,

Erich