Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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?