Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

is qvuser() in expression works in accesspoint

Hi,

Iam using qvuser() in chart expression,is it works in accesspoint

9 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Yes, if you identify your users with USERID (and password). Otherwise, you should use OSUser()

Peter

sundarakumar
Specialist II
Specialist II

it is section access name, it should work in access point too

Not applicable
Author

Hi,

Thanks for your Time

i have user1

expression:sum(amount)

Issue:if(qv user is User1,data should show related to him

how to write in expression

Peter_Cammaert
Partner - Champion III
Partner - Champion III

I don't know. What is the relation between User1 and the data?

Peter_Cammaert
Partner - Champion III
Partner - Champion III

BTW the best way to do this is by using Section Access. With this technique, data will be filtered whenever someone opens your document, and you don't need to add code to your expressions.

Peter

sundarakumar
Specialist II
Specialist II

Section access will itself reduce data with respect to the user login, Please refer to the basic section access document.

Regards,

Sundar

Not applicable
Author

i have requirement like this:

bar chart should show Full data .

Dimension:manager

Expression:sum(spend)

straight table should show only login user informatio

How to use section access ,please help me out

sundarakumar
Specialist II
Specialist II

If that is the case i guess you cannot use Section access to reduce data. You can use if condition as you have specified earlier. Pls post sample for better clarification.

-Sundar

Not applicable
Author

Hi,

Please find the dashboard

login id:3

password:3

if u click on 7-12 Month duration tab by clearing selections

second bar chart will display,in second bar chart click jeffrey wermann.

now third table will come.

But login user id is John apathy.

he cant See jeffery data in third table .restrict data in third table only

Thanks