Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
may be try this
Count
(
{
$<
Ticketstatus_ID *= {7,8,26,28,35,36}
>
}
Comments
)
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
may be try this
Count
(
{
$<
Ticketstatus_ID *= {7,8,26,28,35,36}
>
}
Comments
)
Exactly what i needed, thanks a lot!
what about this
Count
(
{
$<
Ticketstatus_ID = {7,8,26,28,35,36}
> *
<
Ticketstatus_ID = p( Ticketstatus_ID)
>
}
Comments
)