topic Re: ¿Visual filter in table? in App Development

¿Visual filter in table?

Mon, 25 Apr 2016 17:14:43 GMT

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.

Re: ¿Visual filter in table?

sunny_talwar — Mon, 25 Apr 2016 17:16:28 GMT

Are you using all dimensions? Any Expressions?

You can add this to your expression:

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

Re: ¿Visual filter in table?

Mon, 25 Apr 2016 17:20:22 GMT

I have this expression in this table:

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

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

Re: ¿Visual filter in table?

sunny_talwar — Mon, 25 Apr 2016 17:21:56 GMT

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

Re: ¿Visual filter in table?

Anonymous — Mon, 25 Apr 2016 17:33:38 GMT

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

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

this should filter the rows.

Re: ¿Visual filter in table?

Mon, 25 Apr 2016 17:51:14 GMT

In this table,

I take a screenshot in a part of table.

Thanks.

Re: ¿Visual filter in table?

sunny_talwar — Mon, 25 Apr 2016 17:54:21 GMT

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?