topic Re: Display only dimension values without expression in QlikView

Display only dimension values without expression

Thu, 13 Feb 2014 17:00:54 GMT

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 !!!

Re: Display only dimension values without expression

Nicole-Smith — Thu, 13 Feb 2014 17:07:38 GMT

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.

Re: Display only dimension values without expression

stevedark — Thu, 13 Feb 2014 17:13:39 GMT

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.