topic Re: Help in section access problem in QlikView

Help in section access problem

ariel_klien — Tue, 11 Jun 2013 07:49:14 GMT

Hi all,

I am using in my model section access to show specific data to a specific user.

In my model I have one tab that I want to show for a specific user all data

but in the others tabs this user will see what is permitted for him in the section access.

Any idea?

Ariel

permition permition

Re: Help in section access problem

alexandros17 — Tue, 11 Jun 2013 08:10:27 GMT

The only way is loading data again and create another cloud not linked to the one used with section access

Re: Help in section access problem

ariel_klien — Tue, 11 Jun 2013 08:15:20 GMT

Hi Alexander,

Thank you for your answer,

but what do you mean with "create another cloud not linked to the one used with section access"

Ariel

Re: Help in section access problem

alexandros17 — Tue, 11 Jun 2013 08:35:04 GMT

If the field reducted from section access is for example "myField" you have to reload data with another table whose fields have different names from all the field you have (the table or tables don't have to connect to any of tables you have used yet) in this way you will have a set of tables totally disjoined from the tables you manage with section access, this data will not be recucted.

Re: Help in section access problem

ariel_klien — Tue, 11 Jun 2013 08:53:57 GMT

Thanks,

But I want the data redacted for this user except 1 tab.

Ariel

Re: Help in section access problem

ariel_klien — Tue, 11 Jun 2013 11:28:57 GMT

Any suggestion anyone?

Ariel

Re: Help in section access problem

Tue, 11 Jun 2013 12:15:50 GMT

You can create flags. So to view a certain tab the user needs to have certain access rights, then you can add conditional show on the sheet.

Please see attached example.

I have commented out the section access, add your own NTNAME and reload the data. You should only see tab 1.

Go in to the script and change the flag value to 2 and reload the data now you should see tab 1 and 2.

Hope this helps.

Re: Help in section access problem

ariel_klien — Tue, 11 Jun 2013 13:37:39 GMT

Hi Zohaibirshad,

Thanks for your help, but it doesn't what I need.

I need that x user will see all tabs with his data (not other users data) , but in the last tab (and only in the last tab) he will see all other users data + his own data.

I hope that is explaining my problem.

Ariel

Re: Help in section access problem

Tue, 11 Jun 2013 14:39:29 GMT

Hi Ariel,

I understand.

Please see attached example. I have modified the Section Access.

The attached example is based on division. Add your own NTNAME and reload the data you will see sales for divisions 1 and 3 on MyData tabs and all sales by division on the AllData tab.

The data reduction is done on your NTNAME which returns the users division (s).

The division is added to a variable and used in Set Analysis in the straight table.

Hope this helps.

Thanks

Zohaib