Restrict filters in a list box

[Anonymous]

I have data in a QlikView application for four retail pharmacy organisations as listed in the following list box:

Users of all four organisations should be able to see data for all organisations.  However, i need to restrict filtering to each organization in such a way that each organisation only has access to a filter of its own.  For example, GREENWOOD customers should only have access to the GREENWOOD filter with all other filters for the other three organizations not accessible.  Is this possible through QlikView security via section access or another way without having to load different specific documents for each organization through flags?

Thanking you in advance.

[swuehl]

Section access / data reduction will reduce the records in the data model, so it's probably not fulfilling the requirement of 'see all data for all organisations'.

You can maybe use an expression in the list box to filter the values shown based on user information, but if you are using the field as dimension somewhere in your charts, users may still be able to filter on the field.

[Anonymous]

Thank you very much Swuehl, yes i have the fields as dimensions only in sheets specific for each organisation.  I was using an expression in the list box based on a flag from a table.  This means that i need to create a separate document for each organisation and re-loading the data with separate flags for each retail pharmacy, which is laborious.

[swuehl]

Well, maybe I just don't fully understand your setting and requirement.

If you are creating multiple documents, will the users be able to see 'all data for all organizations'?

Maybe it's not all data, but some aggregated facts to be public, and detailed facts are private to single organization?

[Anonymous]

They will see aggregated data, but when they filter with list box with their organisation name by selecting it, they will see the data for their organisation until the selection is cleared.

[swuehl]

If I understand correctly, document chaining would probably be a better approach then.

[satishkurra]

Hi

Apart from document chaining which Swuehl mentioned, you can also look for this....

On Demand App Generation

Thanks

Satish

[Anonymous]

Thanks Swuehl

Being a beginner in QV i do not understand the concept of document chaining and its application in my particular case.

[Anonymous]

Thank you Satish

i am a novice in QV and i do not understand how your recommendation would help

[Peter_Cammaert]

A simpeler solution may be to let Section Access (or some list box expression that filters depending on user name) Nullify (e.g. replace with NULL values) the name of all other organisations except the user's own. A NULL value will never show up in a list box, so you can either clear all selections (thereby including all "NULL" organisation values in aggregation), or select the single user organisation (and thereby excluding the NULL organisation values).

May require some thinking to get a good and flexible name elimination system, but with SA this becomes very simple.

Best,

Peter