topic Table box selection in QlikView

Table box selection

Fri, 15 Apr 2011 10:00:20 GMT

Hi,

in a my report I have more list boxes and one table box. When I select a value for each list box in the table box I can see only the refererred rows. Is it possible to see the selected rows in green colour and the other ones in gray colour without deleting the unselected rows in the table box?

Thanks

Table box selection

Fri, 15 Apr 2011 10:04:03 GMT

in a table you cant do that (i think 😛 )

Table box selection

Miguel_Angel_Baeyens — Fri, 15 Apr 2011 10:08:23 GMT

Hello Andy,

That's not possible. You can configure that in the listbox (show excluded values) but not in the table box, where you can show either excluded or included values, but not both at the same time. I'd work that around creating a straight table instead.

Hope that helps.

Table box selection

Fri, 15 Apr 2011 10:34:26 GMT

Hi,

but in table chart I must manage data as dimensions and measures. At least I need to show a code and the related description.

Thanks

Table box selection

Miguel_Angel_Baeyens — Fri, 15 Apr 2011 10:58:09 GMT

You can use set analysis, the Only() function and 1 or TOTAL in the set analysis to show all values. Without a sample code I cannot go further.

Regards.

Re: Table box selection

Mon, 11 Jun 2012 07:16:07 GMT

Hi Miguel.

Even if this is an old discussion, I'd be interested to know more about your suggestion to use Set Analysis to achieve what Andy needed.

Can you show me using the sample in attachment (table chart "Sells")?

Thank you ver y much

Fabrizio

Re: Table box selection

Mon, 11 Jun 2012 07:47:03 GMT

you can use this one

Re: Table box selection

Mon, 11 Jun 2012 08:00:37 GMT

Thank you!

Re: Table box selection

Miguel_Angel_Baeyens — Mon, 11 Jun 2012 08:06:27 GMT

Hi Fabrizio,

I guess you mean showing all values in the straight table regardless selections made in the two listboxes. If that is right, use the following.

Sum({1} Sell)

The chart will always show all values, although you make selections in the listboxes.

Hope that helps.

Miguel

P.S.: Do not hesitate to open a new thread and linking to old ones ("I have been checking this thread and I have a similar issue"), instead of "reviving" old posts that are no longer active.

Re: Table box selection

Mon, 11 Jun 2012 09:04:54 GMT

Hi Miguel.

Yes, exactly what I was looking for.

And thank you for the hint about the new thread as well.

Regards

Fabrizio