Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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?