How to apply a join query in an expression

[Jothi]

I am trying to come up with an Expression. I have a bar chart that shows the Number of times a product is ordered per Product. I want the chart to show only certain products, and the products to be shown are to be filtered based on a query.

For example, the expression in the Product dimesion should be something like ProductId where productid in (select productid from UserToProductMapping where Userid = OSuser())

[MayilVahanan]

Hi

Try like something below

Count({<UserID={'$(=OSUSER())'}>}Distinct ProductId)

or

Only({<UserID={'$(=OSUSER())'}>}ProductId)

[Jothi]

Hi @MayilVahanan ,

Thanks, I am new to qliksense and now I have learnt that, Section access is what I should be using for the usecase I am trying. I needed to restrict the data, based on the logged on user.

[MayilVahanan · Accepted solution]

Hi

Below link helps on section access.

https://help.qlik.com/en-US/sense/May2021/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/manage...

[Jothi]

Yes, but it doesnt mention how to view the content of the Authorisation table. Any pointers to that?