topic Re: Straight table problem in QlikView

Straight table problem

Wed, 03 Dec 2014 03:24:20 GMT

Hello,

As like attached pic I have two straight tables, in both the tables i have different dimensions and same expressions and am swapping rows as columns. i want to put these two tables side by side and t want to hide the expression from second table so that it looks like single table but i am not finding a way for this is there a way to hide the dimension in straight table. Please help me with the solution.

Re: Straight table problem

Wed, 03 Dec 2014 04:09:24 GMT

Hii Anin,

You can hide the dimension of second chart.

Go to properties of second chart, in presentation tab, select dimension listed above and there is an option 'Hide Column'. Your dimension will disappear.

Regards,

Lalit

Re: Straight table problem

Wed, 03 Dec 2014 04:14:11 GMT

Hi Lalit,

Thanks for the replay, sry there was mistake in my post. I need to hide the expression not the dimension, please read my above query once again i have corrected my question now.

Re: Straight table problem

tresB — Wed, 03 Dec 2014 04:37:47 GMT

You can use straight table without an expression, you just have to uncheck 'Supress Zero Values' in the presentation tab.

Re: Straight table problem

Wed, 03 Dec 2014 05:38:09 GMT

Anin,

It is possible to hide expression in straight table. If you are using straight table, then apply this.

If you are using Pivot table then its not possible to hide expression. In this case you can change font color of that expression to white or similar to the background color so that expression will look disappeared.

Try it

-Lalit