Custom Filters depending on User

[nickmarlborough]

Hi, 

two questions, both regarding custom filters:

1) is there a way to have the sheet pre filtered depending on the user. For example i have a unique ID - is there a way Qlik can see what unique ID is accessing the dashboard and filter a field accordingly?

2) slightly less complex - is there a way to have pre filters such as 'IF XYZ, then filter CITY on LONDON'

Thank you

[JHuis]

is section acces not what you want to archieve?

[nickmarlborough]

Hi, 

What do you mean by section access?  as in only certain users can view certain sheets?

If so.... no - i would just like predefined filters set depending on who is looking at the sheet? 

For example - if i only wanted you to see the CITY London - id have filter predefined for you so when you click to the sheet, London is already filtered. Whereas for myself, it would be New York

[JHuis]

Section acces is that you give user filters for a subset of the data. In this example you only see londen and i can only see new york.

If that is want you want you need section acces, otherwise i have also an idea

[nickmarlborough]

Hi, 

i dont want to prohibit access - however the filters are more initial suggestions. 

What would be the other idea?

[JHuis]

You could use OSUser() then like 

If(OSUser()='USERNAME',Londen) etc.

then you could use the sheet actions and select a value inside a field.