topic Section Access - restricting access based on two columns in QlikView

Section Access - restricting access based on two columns

Mon, 27 Jul 2009 17:22:04 GMT

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.

Section Access - restricting access based on two columns

Mon, 27 Jul 2009 18:08:28 GMT

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.

Section Access - restricting access based on two columns

Mon, 27 Jul 2009 18:28:31 GMT

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

Section Access - restricting access based on two columns

Mon, 27 Jul 2009 20:57:05 GMT

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.

Section Access - restricting access based on two columns

Wed, 29 Jul 2009 17:58:37 GMT

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

Section Access - restricting access based on two columns

Thu, 30 Jul 2009 02:50:40 GMT

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

Section Access - restricting access based on two columns

Fri, 21 Aug 2009 17:08:15 GMT

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.

Section Access - restricting access based on two columns

Wed, 18 May 2011 10:30:49 GMT

Hi Jay,

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