Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

STRAIGHT TABLE ISSUE

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

Labels (1)
5 Replies
swuehl
Champion III
Champion III

Maybe by removing the dimensions from the straight table?

Not applicable
Author

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

swuehl
Champion III
Champion III

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

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

Replace YourExpression with your current expression for that column.

Not applicable
Author

Hi, try

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

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

HirisH_V7
Master
Master

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 .

HirisH