topic Invisible row in diagram (pivot/strait-table) in QlikView

Invisible row in diagram (pivot/strait-table)

Tue, 26 Jan 2010 15:11:27 GMT

Hi,

Is it possible to "hide a row" in a pivot- and straight table.

Either by eliminating the row from beeing seen or making the text the same as background color.

I still need the values connected to the row to be calculated.

Regards
Arne W

Invisible row in diagram (pivot/strait-table)

Tue, 26 Jan 2010 15:21:27 GMT

Go on property of the chart, expression, then click on enable case to show or to hide your row.

Invisible row in diagram (pivot/strait-table)

Tue, 26 Jan 2010 15:39:42 GMT

Hi,

JJ - It is one of the rows (dimension) I need to hide and I guess your suggstion is about the columns

(I am working in version 8.2 )

/Arne W

Invisible row in diagram (pivot/strait-table)

Tue, 26 Jan 2010 15:50:09 GMT

Yes sorry I misreaded your request.

You can hide the row with a listbox, or with a calculated dimension = if ( condition to display your dimension , dimension)

Invisible row in diagram (pivot/strait-table)

Tue, 26 Jan 2010 21:20:00 GMT

The row have to exist in the table as the value must be included in the total.
Is it possible to set the textcolor for the whole row to be the same as background?

/Arne W

Invisible row in diagram (pivot/strait-table)

prieper — Tue, 26 Jan 2010 23:09:42 GMT

Not quite sure, whether it is a good idea to add something without specifying, but you may also then use a calculated dimension in which you change the dimension into blanks, like

IF(Dimension = DimensionNotToShow, ' ', Dimension)

HTH
Peter

Invisible row in diagram (pivot/strait-table)

Wed, 27 Jan 2010 00:08:37 GMT

Hi,

You could use the rowno() function to change the color of the row. But first there should be somehting for your to detect which row you wan to do this for. This will depend on your data model. Maybe if you post an example, it may be more clear. But for example, whenever I want to provide different colors for alternate rows in a straight table, I use the followig formula in the background color for both dimesnsions and expressions.

=if(Mod(rowno(),2)<>0,rgb(100,100,100))

Nimish

Invisible row in diagram (pivot/strait-table)

Mon, 28 Mar 2011 04:14:40 GMT

I guess you want to render an expression as 'invisible'. This function is available for Bar Chart, Line Chart and Combo Chart but unfortunately for Straight & Pivot Table.

I have the same problem here.

Let's say, I have 2 complex expressions (A & B) and I am interested to have the sum of both (C = A+B)

At final, I am not interested to display A & B, but want to keep them for debugging purpose, also want to avoid to carry a very complex expression in C

I can't uncheck 'Enable' for A & B, otherwice C (=A + B) won't be calculated.