topic Tablebox viewing not all Data in QlikView

Tablebox viewing not all Data

Mon, 12 Mar 2012 16:48:53 GMT

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

Tablebox viewing not all Data

pover — Mon, 12 Mar 2012 17:04:24 GMT

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

Tablebox viewing not all Data

Tue, 13 Mar 2012 16:52:24 GMT

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

Tablebox viewing not all Data

pover — Thu, 15 Mar 2012 00:37:35 GMT

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