How do I filter a straight table in QlikSense

Eugene81 — Mon, 29 Jul 2024 13:12:55 GMT

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)

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

Re: How do I filter a straight table in QlikSense

lennart_mo — Mon, 29 Jul 2024 15:17:15 GMT

Hi @Eugene81

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

if(App='App1', User)

Hope this helps!

Re: How do I filter a straight table in QlikSense

Eugene81 — Mon, 29 Jul 2024 15:23:24 GMT

Thank you so much @lennart_mo it perfectly worked

Subject solved

topic How do I filter a straight table in QlikSense in App Development

How do I filter a straight table in QlikSense

Re: How do I filter a straight table in QlikSense

Re: How do I filter a straight table in QlikSense