Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

j_schmidt
Contributor

Table + Set Analysis + Filtering

Hi,

i am fighting with a strange behavior with a Qlik Sense table chart.

I habe a very simple example:

Table with two dimensions:

- Ticket

- Status

And one Metric:

Count (Comments)

When i filter now for a certain status, the table shows me exatcly the rows where the status field matches.

Alle good until here.

Now i add a Set Analysis because i only want to show tickets with a certain status:

Count

(

    {

        $<

            Ticketstatus_ID = {7,8,26,28,35,36}           

        >

    }

    Comments

)

Now, when i filter a status, the rows in the table stay the same.

I would expect that when i filter for status = 26 that only those rows are shown.

When i want to filter for status = 508, the table shouldnt show any rows.

However, the table always shows the same rows.

Am i missing something here?

Thanks in advance,

John

Tags (2)
1 Solution

Accepted Solutions

Re: Table + Set Analysis + Filtering

may be try this

Count

(

    {

        $<

            Ticketstatus_ID *= {7,8,26,28,35,36}          

        >

    }

    Comments

)

4 Replies
omarbensalem
Esteemed Contributor

Re: Table + Set Analysis + Filtering

Because you've already forced the table to always show the status 7,8,26,28,35,36 by including them in ur set analysis

Re: Table + Set Analysis + Filtering

may be try this

Count

(

    {

        $<

            Ticketstatus_ID *= {7,8,26,28,35,36}          

        >

    }

    Comments

)

j_schmidt
Contributor

Re: Table + Set Analysis + Filtering

Exactly what i needed, thanks a lot!

pradosh_thakur
Valued Contributor III

Re: Table + Set Analysis + Filtering

what about this

Count

(

    {

        $<

            Ticketstatus_ID = {7,8,26,28,35,36}          

        > *

<

            Ticketstatus_ID = p( Ticketstatus_ID)   

        >

    }

    Comments

)