section access reduction conditionally.

[Anonymous]

Hi There,

This is enhancement to the solution i received in previous discussion(link below)

I wanted to create section access with data reduction on multiple fields(PRODUCT, SYSTEM, LOCATION, BUSINESSAREA). Please see my attached app.

filter table data

My Requirement is to perform data reduction on only Sales table and its matching Problems data and don't reduce data in the Problems table that are not matching with sales table. I mean, i wanted to do conditional data reduction.

I have created dummy values in Problems table as below, but still the data reduction is happening.

PALL as Product

SALL as System

LALL as Location

BALL as BusinessArea

I have disabled strict exclusion in the settings, but not sure whether it is correct for my requirement.

The logins of the file is-

userid-- USER

password-  USER

Please help!

[Peter_Cammaert]

There is no such thing as "conditional data reduction". Data is either reduced away because of not being linked to the current SA table entry, or kept available because of being linked to the current SA table entry.

All links in this story are explicit, as they are in every QlikView Data Model.

If you want to reduce some data and keep some other data, you have to make sure that at all times links exist to all tables and all rows that you want to keep, no matter who is accessing your document.

Best,

Peter

[Anonymous]

If you want to reduce some data and keep some other data, you have to make sure that at all times links exist to all tables and all rows that you want to keep, no matter who is accessing your document.

Best,

Peter

Hi Peter,

Thanks for your reply.

Could you please explain me the above statement with a example.

Also, if possible could you use my sample app to show it.

Thanks for your time!

[florentina_doga]

pls see attach

[florentina_doga]

and for user modify acces like this

[florentina_doga]

maibe this

[florentina_doga]

try to user user

or admin admin

password and user

[Anonymous]

Hi Florentina,

Mine is a data reduction problem.

I think i am not clear with my requirement.

I have now simplified my the model with comments in the script.

All i want section access to reduce the data on fields in Sales table, but not in Problems table.

eg- PRODUCT field should show 'ZZ' value in the listbox.

eg- similarly, SYSTEM field should show 'Peoplesoft' and 'Microsoft' values in listbox.

My front end requirement is to analyze Sales & Problems data side by side, so i want to concatenate both the fact tables. I am find with duplicating the fields the common fields if that solves my problem.

logins-

user-  user

password- user

Please help!

[florentina_doga]

hi

You had no connection between the facts and the discount table.
I hope to be what you want

[Anonymous]

Any inputs please.