topic How to write Section access Based on Measures ? in QlikView

How to write Section access Based on Measures ?

shekhar_analyti — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

How to write Section access Based on Measures

Requirement :

1) If any of the managers opens the application then he/she should see only sales data of his own , highest sale and lowest sale in chart and then his position in text box .

But should not be able to loss and revenue data .

2) If ADMIN opens the application then he/she should see all the 3 chart and data of slaes , loss and revenue .

3) If USER2 opens the application then he/she should see 1 chart showing and data of revenue only .

4) If USER3 opens the application then he/she should see 1 chart showing loss and data of loss only .

Thanks & Regards

Shekar

Re: How to write Section access Based on Measures ?

Peter_Cammaert — Tue, 09 May 2017 08:06:25 GMT

You cannot base "Section Access on measures" because SA manages your data and some extra data model elements. You can however add flags to your SA data as pseudo-permissions and use them in the conditional show expressions of objects, sheets, dimensions and expression. Or you can use the OMIT feature to drop some of your facts for specific users. The expressions that use these facts will follow suit and disappear from your charts due to lack of data.

Re: How to write Section access Based on Measures ?

shekhar_analyti — Tue, 09 May 2017 08:09:36 GMT

Hi Peter ,

Thanks for reply .

It will be really helpful if you can attach sample using my qvw .

Re: How to write Section access Based on Measures ?

shekhar_analyti — Tue, 09 May 2017 08:26:52 GMT

any workaround loveisfail‌stalwar1‌

Re: How to write Section access Based on Measures ?

Peter_Cammaert — Tue, 09 May 2017 08:32:30 GMT

The technique is very well explained by Jagan here: Chart Level Access by user

The same trick can be used to show/hide dimensions and expressions.

Re: How to write Section access Based on Measures ?

Anil_Babu_Samineni — Tue, 09 May 2017 09:01:15 GMT

Is this you are expecting? I've table like below

If, Application Login from User for A. Are you looking for this?

And Table box is this?

Re: How to write Section access Based on Measures ?

shekhar_analyti — Wed, 10 May 2017 05:08:10 GMT

If A logins then sales of A , Sales B or D which is highest and sales of C (if its less than A),

Basically sales of user A and sales of another user which is maving Maximum sales and sales of user which is having minimum sales

Re: How to write Section access Based on Measures ?

Anil_Babu_Samineni — Wed, 10 May 2017 05:30:27 GMT

Sorry to say, Not getting anything.

From my data what would be the output if A login happened or share sample data set and explain bit more