How do I filter a straight table in QlikSense

[Eugene81]

Hello Everyone,

I have a question regarding filtering a straight table.
I have a list of users that can access applications (this is an exemple, the database is larger)

  User  |  App
-------------------
User 1 | App1
User 4 | App1
User 2 | App1
User 2 | App2
User 3 | App2
User 4 | App3
User 3 | App3
User 2 | App3

I want to have 3 tables that look like this :

Table - App1
-------------------
User1
User 4
User 2

Table - App2
-------------------
User2
User3

Table - App3
-------------------
User 4
User 3
User 2

the count function work : count({<App={'App1'}>}[User])
but the way to show the only list doesn't, I've tried :

Aggr(({<{App={'App1'}>} [User]), [User])
if (App={'App1'},[User],'')
only({<{App={'App1'}>}[User])

Can someone please help me on this problem ?
Thanks in advance

[lennart_mo · Accepted solution]

Hi @Eugene81 

I think you may have just used a slightly wrong syntax.
Try this:

if(App='App1', User)

Hope this helps!

[Eugene81]

Thank you so much @lennart_mo it perfectly worked

Subject solved