topic Can user access some data in one sheet which access is rejected in other sheets? in QlikView

Can user access some data in one sheet which access is rejected in other sheets?

Fri, 04 Mar 2011 07:34:04 GMT

hi,

I want to use section access to do this. But if use data reduction, all sheets' data is reduced. Can I control this separately.?

Can user access some data in one sheet which access is rejected in other sheets?

Fri, 04 Mar 2011 08:35:24 GMT

For example, in sheet1 , I want user access data of year=2008,2009 . And in sheet2 I want user access data of year=2010(2008,2009 is denied)

Can user access some data in one sheet which access is rejected in other sheets?

Fri, 04 Mar 2011 15:08:32 GMT

Hello,

I dont know if I understood your actual requirement, however you may do a Sheet Properties and then add a action to trigger Clear All, On Sheet Activate, so that when you go to sheet 2 all the data is cleared and then select Year again.

Or you can also try creating another Year field CopyYear and then In sheet one use Year and then in Sheet 2 use CopyYear and then have a value 2008 selected in Sheet2 always...However be careful with other things then.. You might have to change the dimensions on other charts as well for Sheet 2.

ANDY

Can user access some data in one sheet which access is rejected in other sheets?

Sat, 05 Mar 2011 03:07:18 GMT

Hi,

In your second idea, if I create another Year field COPYYEAR, then old year field will relate COPYYEAR. If I select a year2008 in one sheet, the other field COPYYEAR will be selected because of the relation.

Can user access some data in one sheet which access is rejected in other sheets?

suniljain — Sun, 06 Mar 2011 11:10:11 GMT

you can use set analysis in this case

you can avoid year 2010 in first sheet set analysis expression and you can avoid 2008,2009 in second sheet in set analysis expression .

if you require more details , reply me.

Can user access some data in one sheet which access is rejected in other sheets?

Mon, 07 Mar 2011 04:52:34 GMT

Hi,

set analysis, cannot solve my problem.

I want different user access different data in different sheets.like:

John can access 2008 and 2009 data in sheet1, and 2006~2009's data in sheet2. .....

user	sheet1	sheet2
John	2008/2009	2006/2007/2008/2009
Tom	2006/2007	2008
ABC	2008/2009	2006

Use section access I can do this:

user	sheet1	sheet2
John'	2006/2007/2008/2009	2006/2007/2008/2009
Tom	2006/2007	2006/2007
ABC	2006	2006

Can user access some data in one sheet which access is rejected in other sheets?

suniljain — Mon, 07 Mar 2011 10:59:42 GMT

If this is the case then set analysis will not work.

Can user access some data in one sheet which access is rejected in other sheets?

Mon, 07 Mar 2011 17:25:30 GMT

Hi,
You can maybe try a combination of section access and set analysis. By adding a table that will link users, years, and sheets you will be able to do it :

Section Access;
users:
LOAD * INLINE [
ACCESS, USERID
admin, ADMIN
user, JOHN
user, TOM
user, ABC
];
Section Application;

data:
LOAD year,
data
FROM
C:\Work\Tmp\nada.txt
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

restriction:
load * inline [
sheetName, USERID, year
Document\SH02, JOHN, 2008
Document\SH02, JOHN, 2009
Document\SH03, JOHN, 2006
Document\SH03, JOHN, 2007
Document\SH03, JOHN, 2008
Document\SH03, JOHN, 2009
Document\SH02, TOM, 2006
Document\SH02, TOM, 2007
Document\SH03, TOM, 2008
Document\SH02, ABC, 2008
Document\SH02, ABC, 2009
Document\SH03, ABC, 2006
];

You can now use a set analysis like sum({$<sheetName={$(=GetActiveSheetId())}>}data).

Hope this helps,

Can user access some data in one sheet which access is rejected in other sheets?

Tue, 08 Mar 2011 02:32:43 GMT


RenaudCharlet wrote:
Hi,
You can maybe try a combination of section access and set analysis. By adding a table that will link users, years, and sheets you will be able to do it :
You can now use a set analysis like sum({tiny_mce_markerlt;sheetName={$(=GetActiveSheetId())}>}data).
Hope this helps,
 <div></div>

Hi, this is a good idea. And I test it OK.

I have about 30 charts in each sheet. (10 sheets total). Use set analysis, I have to re-edit hundreds of chart objects .[:'(]

Is there any simpler idea? Thank you.

Can user access some data in one sheet which access is rejected in other sheets?

maneshkhottcpl — Tue, 08 Mar 2011 03:10:01 GMT

Hi,

The trick given by above post is very good. If u have many users and need to controll the access u can create the Table (Matrix) in excel sheet instead of inline table.

Can user access some data in one sheet which access is rejected in other sheets?

Tue, 08 Mar 2011 03:27:03 GMT

Hi Manesh,

I mean I have to write many set-analysis expression in hundreds of charts. Can this be simpler?

Can user access some data in one sheet which access is rejected in other sheets?

maneshkhottcpl — Tue, 08 Mar 2011 03:34:39 GMT

Hi,

I will try to find some solution and revert u back.

Can user access some data in one sheet which access is rejected in other sheets?

michael_anthony — Tue, 08 Mar 2011 04:21:15 GMT

If you use an OnActivate sheet action (or event for v8) when the user switches sheets. You could then force the selection of the relevant year(s) and lock the selection using a macro.

Also, might pay to create a COPYYEAR field which is what you apply to selection on. You could also designate COPYYEAR as a system field (Use HidePrefix method) which makes it a bit harder for user to undo your select / lock step.

Wasn't sure from your requirements if the sheet should only show certain years for all users, or if a sheet should show certain years depending the user. eg. John sees 2010 and 2011 in sheet2, but Bob can only see 2010 in sheet2. If so, makes the macro a bit more complex, but not unworkable.

An alternative may be to create a listbox that includes the set analysis formula as a selection expression and have the macro select the valid values in the listbox. eg. =If(Count({set expr} COPYYEAR)>1,COPYYEAR)

Can user access some data in one sheet which access is rejected in other sheets?

Tue, 08 Mar 2011 06:05:44 GMT

My requirements is: if a sheet should show certain years depending the user. eg. John sees 2010/2011 in sheet2 and 2009 in sheet3 , but Bob can only see 2010 in sheet2.

Can user access some data in one sheet which access is rejected in other sheets?

Tue, 08 Mar 2011 08:26:18 GMT

hi Michael

Could you pls show me the details about the Macro.

Can user access some data in one sheet which access is rejected in other sheets?

Fri, 11 Mar 2011 02:54:59 GMT

Any good idea?

This question worried me many days.

Can user access some data in one sheet which access is rejected in other sheets?

Fri, 11 Mar 2011 03:09:57 GMT

Any one can help me .

I'm thinking about this for many days.

Can user access some data in one sheet which access is rejected in other sheets?

Mon, 27 Jun 2011 11:03:25 GMT

Hi,

A very simple solution to your problem, could be to use two diffrent qvw files and tie them together with document chaining.

If not to heavy (not to many rows and fields) , with transfer status and open in same window (Ajax client) the user would not notice the change of qvw file....

Both document of corse have to use the Section Access described above.

You could have a master document to do the fully load then have the two qvw file do a binary load from the master. After the binary you could reduce the year accordingly and distribute them.

BR Hans

Re: Can user access some data in one sheet which access is rejected in other sheets?

Mon, 18 Feb 2013 11:08:08 GMT

Hello Hansiola,

I'm very interested by your solution, because i'm stucked with the same problem.

Could you give please more expalanation about the solution by loading the two qvw files into one master qvw file?

Regards