Tablebox viewing not all Data

[#1]

Hello.

I have a Tablebox, which is viewing all "changes" made to ONE Ticket.

It only views DATA, if ONE Ticket is selected.

I want to show all these "changes" all the time, ignoring all other selections been made, like Day, Month etc.

Is this possible?

Regards,

Michael

[pover · Accepted solution]

Instead of using a table box, use a straight table that has all the dimensions that are defined in the table box and an expression like the following

only({1<Ticket={'$(=only(Ticket))'}>} Ticket_ID)

That expression will ignore all selections except those made in the ticket filter.  You would have to select only one ticket to see the table.

Karl

[#3]

Ah, thanks for that.

One last question:

The part "...only(Ticket)...": only is not necessary, if i see it right?

With this expression, i get the same result:

only({1<Ticket={'$(=Ticket)'}>} Ticket)

I assume the result is the same, because the first "only" already gets the "Ticket" filtered?

Regards,

Michael

[pover]

It's basically the same thing.  Using only() is a good practice because it allows you to do set analysis on a field without using a aggregation and in my opinion a field should never be with a function when it is used as an expression.  But it's not required by QV.

Karl