Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
shekhar_analyti
Specialist
Specialist

How to write Section access Based on Measures ?

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

7 Replies
Peter_Cammaert

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.

shekhar_analyti
Specialist
Specialist
Author

Hi Peter ,

Thanks for reply .

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

shekhar_analyti
Specialist
Specialist
Author

any workaround loveisfailstalwar1

Peter_Cammaert

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.

Anil_Babu_Samineni

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

Capture.PNG

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

Capture.PNG

And Table box is this?

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
shekhar_analyti
Specialist
Specialist
Author

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

Anil_Babu_Samineni

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)