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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Display only dimension values without expression

Hello,

Is it possible to show only dimension values without any expression.

I have one ad-hoc report,I wants that even expression is not selected,it should display only dimension values.

Thanks in advance !!!


1 Solution

Accepted Solutions
Nicole-Smith

You'll need a "dummy" expression.  Just use '' or 1 and all dimensions will display.  If you use the '', it will look as if the column is empty (if you're using a pivot table) or you can hide the column if you're using a straight table.

View solution in original post

2 Replies
Nicole-Smith

You'll need a "dummy" expression.  Just use '' or 1 and all dimensions will display.  If you use the '', it will look as if the column is empty (if you're using a pivot table) or you can hide the column if you're using a straight table.

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

Is a Straight Table without any expressions a Table Box?  Rather than picking the Chart option from the New Sheet Object menu pick Table Box and you are away.

If there is a reason why it needs to be a chart (more control over cell colours etc.) you can do exactly as Nicole suggests and have an expression of 1 and hide the column on the Presentation tab.