Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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!
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
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!
pls see attach
and for user modify acces like this
maibe this
try to user user
or admin admin
password and user
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!
hi
You had no connection between the facts and the discount table.
I hope to be what you want
Any inputs please.