Section Access - restricting access based on two columns

[#1]

Hi All!

This question has been asked already, gone unanswered and then archived 🙂 , here: http://community.qlik.com/forums/p/14817/57850.aspx#57850

Basically, I want users access to be based on two columns not just one.

e.g.

Sales data:

ID	RegionType1	RegionType2
1	A	A
2	A	A
3	A	B
4	B	B
5	B	A

User Access:

User	RegionAccess
Pete	A
Andy	B
Roger	A
Roger	B

I want Pete to have access based on region A, in both columns. So Pete should see records 1,2,3 & 5. Andy should see 3,4 &5, and Roger should see all of them.

Has anyone had the same need and found an answer yet?

Help would be much appreciated!

Jay.

[#2]

A bit of further detail: The other thing is that I want to get a dataset of unique records if at all possible, like in a SQL OR query.

[#3]

Maybe something like this? Open with admin / admin.
Greetz Robbie

[#4]

Thanks for replying Robbie.

Okay, I've been trying to understand how concatenate works. The initial view looks good, and the regions give the records they are supposed to in my example above.

But I added a quantity field to see how the data is held, and it looks like the data is effectively doubled, and the ID listbox is just selecting distinct values, because if I sum the quantity by region, each region has twice the quantiy it should have. The same thing can be done by creating a third field and unioning the data in SQL. Thats why I needed to acutally select the data based on both fields.

Does that make sense? The way I expect to present this is to have one set of data without duplicates and show the sales data on one sheet with the RegionType1 filter, and on another sheet with a RegionType2 filter.

Jay.

[#5]

Anyone at all? A few people must have wanted to do this before!!

[#6]

Hi Jay,

Maybe I'm getting your case wrong, but why would add quantity to your security settings?
Shouldn't quantity be a part of your sales data? See attachment.

Greetz
Robbie

[#7 · Accepted solution]

Woah, sorry for the late reply Robbie, just saw your post! The quantity was not part of the security settings, but the sales data as you said. I was using it to check what was being loaded.

I spoke to a consultant about this, and the upshot is that this cannot be done. The way I fixed it was to do something similar to concatenating, namely have a third field in the database which identifies different sets of data based on both fields.

This was one of our early options, I had rejected it initially because I could not find a way of fixing that field in the filters, which caused data to double up if a value was not selected for the new field in the filters. The consultant showed me a way to do this which solved the problem.

Thanks for taking the time to work on this.

[#8]

Hi Jay,

Can you explain how you got to achieve this? I need the same thing.