topic Measure as a dimension in QlikView

Measure as a dimension

Thu, 14 Apr 2011 16:13:33 GMT

Hi,

for a report it is asked me to put some measures one below other one, thus on rows and not on columns. Then I must have a total not named "Total" but with a custom name. This picture is a simple example about the result to obtain:

I think to use a tabular chart and to create an amount type dimension or similar.

Any suggests to me, please? Thanks

Measure as a dimension

Thu, 14 Apr 2011 16:33:24 GMT

Hi,

Try Chart Properties -> Presentation and check the horizontal flag

In tab presentation you can also change the total label.

Measure as a dimension

Thu, 14 Apr 2011 17:18:04 GMT

Thanks, but I cannot see any horizontal flags in the Presentation tab of the properties of my chart. ???

Measure as a dimension

erichshiino — Thu, 14 Apr 2011 18:42:53 GMT

I agree with Stefano.

but I has to be a straight table to have the horizontal property

Measure as a dimension

Thu, 14 Apr 2011 18:44:13 GMT

The flag is only for straight tables, not pivot

Measure as a dimension

Fri, 15 Apr 2011 08:12:22 GMT

Your suggest is certainly useful, but I need to use a pivot table. I have also year and month as dimensions.

Thanks

Measure as a dimension

Fri, 15 Apr 2011 08:30:49 GMT

Have You tried to drag measures vertically?