Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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())
Hi
Below link helps on section access.
Hi
Try like something below
Count({<UserID={'$(=OSUSER())'}>}Distinct ProductId)
or
Only({<UserID={'$(=OSUSER())'}>}ProductId)
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.
Hi
Below link helps on section access.
Yes, but it doesnt mention how to view the content of the Authorisation table. Any pointers to that?