Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

¿Visual filter in table?

Hi there,

I have the following table:

BORRAR.jpg

I need show ONLY tickets that are 'CM' and 'Assigned' in the table.


Im working in QlikSense.


Thanks you.

6 Replies
sunny_talwar

Are you using all dimensions? Any Expressions?

You can add this to your expression:


{<Tracker = {'CM'}, Status = {'Assigned'}>}

Not applicable
Author

I have this expression in this table:

(Count({$<[Tracker]={'CM'},[Status]={'Assigned'}>}(#)))

and works to count, but in the table appear others Tracker.

sunny_talwar

You are using this expression outside this table or within this table?

Anonymous
Not applicable
Author

Perhaps you can use an expression in the Ticket field. Something like:

if(Tracker = 'CM' and Status = 'Assigned', Ticket,)

this should filter the rows.

Not applicable
Author

In this table,

I take a screenshot in a part of table.

Thanks.

sunny_talwar

The screenshot you posted did not show any expression for count (or nothing in there looks like a count). Would you be able to add another screenshot with the count in it?