Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I have the following table:
I need show ONLY tickets that are 'CM' and 'Assigned' in the table.
Im working in QlikSense.
Thanks you.
Are you using all dimensions? Any Expressions?
You can add this to your expression:
{<Tracker = {'CM'}, Status = {'Assigned'}>}
I have this expression in this table:
(Count({$<[Tracker]={'CM'},[Status]={'Assigned'}>}(#)))
and works to count, but in the table appear others Tracker.
You are using this expression outside this table or within this table?
Perhaps you can use an expression in the Ticket field. Something like:
if(Tracker = 'CM' and Status = 'Assigned', Ticket,)
this should filter the rows.
In this table,
I take a screenshot in a part of table.
Thanks.
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?