Table + Set Analysis + Filtering

[schmidtj]

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

[OmarBenSalem]

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

[MK_QSL · Accepted solution]

may be try this

Count

(

    {

        $<

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

        >

    }

    Comments

)

[schmidtj]

Exactly what i needed, thanks a lot!

[pradosh_thakur]

what about this

Count

(

    {

        $<

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

        > *

<

            Ticketstatus_ID = p( Ticketstatus_ID)   

        >

    }

    Comments

)