Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

CAN WE USE MULTIPLE FIELDS AS REDUSE FIELD IN SECTION ACCESS

I have a requirment in which i have to reduce data using sections with 6 fields can this be achieved ?

3 Replies
martin59
Specialist II
Specialist II

Hi,

Yes you can, you just have to concatenate your fields.

It will become to be harder if those fields are in different tables.

Hope that helps you

Martin Favier

Not applicable
Author

Hi,

You may create an extra table with:

Field A (like Access) - The 6 other fields

This field A will be used in your Section Access.

So,

you may concatenate your fields and use them  (it will like a AND : Field 1 AND Field 2 AND ....)

create as many lines as needed in Field A (it will be like a OR : first line A or second line A or third line A ...)

Fabrice

hic
Former Employee
Former Employee

You can, but if you keep them as separate fields you can run into problems. See more here: http://community.qlik.com/message/447028#447028

To do it properly, you need to create generic keys. See more here: http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/02/complex-authorization

HIC