topic Re: filtering data for a whole sheet in QlikView

filtering data for a whole sheet

Mon, 06 Feb 2012 12:53:15 GMT

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!

filtering data for a whole sheet

swuehl — Mon, 06 Feb 2012 13:16:00 GMT

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)?

Re: filtering data for a whole sheet

Tue, 07 Feb 2012 07:30:31 GMT

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.

Re: filtering data for a whole sheet

erichshiino — Tue, 07 Feb 2012 10:07:39 GMT

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