topic Re: show all results on a simple table in QlikView

show all results on a simple table

Tue, 10 Feb 2015 10:14:34 GMT

Hi Everybody,

I have a simple table with 2 dimensions, and I want to be able to select a field inside that dimension and still be abble to see all data from the table (in gray like a list). I dont want to only see my selections.

I really hope that this is possible.

thank you beforehand!

Re: show all results on a simple table

Tue, 10 Feb 2015 11:27:36 GMT

Hi,

PFA

Hope this will be helpful

Re: show all results on a simple table

Gysbert_Wassenaar — Tue, 10 Feb 2015 11:31:41 GMT

For that you'll have to use a straight table instead of a table box. See attached example.

Re: show all results on a simple table

Tue, 10 Feb 2015 16:43:28 GMT

it is perfect! nonetheless when I select a field the others turn gray (which is perfect) but when I create the tables it does not change colors. Do you know how to do that?

Re: show all results on a simple table

Gysbert_Wassenaar — Tue, 10 Feb 2015 19:34:29 GMT

Click on the + in front of a dimension on the Dimensions tab of the charts properties window. Then click on the Background Color and then click the Edit button. In the expression editor you will find the expression that calculates the background color for that dimension.

Re: show all results on a simple table

Wed, 11 Feb 2015 07:58:35 GMT

Thank you very much for your help!!