topic Re: STRAIGHT TABLE ISSUE in QlikView

STRAIGHT TABLE ISSUE

Sun, 25 Oct 2015 16:17:20 GMT

Is there a way I can see only the Total and hide the cell contents as in the attached screen shot in a Straight Table

swuehl — Sun, 25 Oct 2015 16:39:31 GMT

Maybe by removing the dimensions from the straight table?

Sun, 25 Oct 2015 16:40:42 GMT

NO cuz I have other columns which I need, so cant remove the Dimension

swuehl — Sun, 25 Oct 2015 16:43:58 GMT

Maybe using Dimensionality() in your expression to check for total line:

=If(Dimensionality() = 0, YourExpression, ' ')

Replace YourExpression with your current expression for that column.

Sun, 25 Oct 2015 18:39:42 GMT

Hi, try

=If(RowNo() = 0, <<your expression>>)

or make a trick and assign column font color = background color (:

HirisH_V7 — Sun, 25 Oct 2015 18:50:02 GMT

you can go with a text box if you want only total it self.

or else

In straight table you can go with a dimensionality()=0 function for total line itself and by making Supress Header Row in presentation tab .